Hi There,
I am totally new to PowerPivot and have being trying to create a SumIf Excel formula.
The Excel formula is:
=SUMIF($E$8:$E$736,">="&E17,$E$8:$E$736)/SUM($E$8:$E$736)
The formula works out a % of sales volume that I then use to apply a grade.
I have been trying to use CALCULATE and FILTER but am unable to achieve the required results.
I appreciate any help that can be given or perhaps point me in the direction of what DAX formula would be best to use.
Thanks.
I am totally new to PowerPivot and have being trying to create a SumIf Excel formula.
The Excel formula is:
=SUMIF($E$8:$E$736,">="&E17,$E$8:$E$736)/SUM($E$8:$E$736)
The formula works out a % of sales volume that I then use to apply a grade.
I have been trying to use CALCULATE and FILTER but am unable to achieve the required results.
I appreciate any help that can be given or perhaps point me in the direction of what DAX formula would be best to use.
Thanks.