Forum Discussion
Solved
Formula Help (SUMIF not available)
Hi All, Need some Power BI formula geniuses. I have a formula which I have created in Excel and trying to replicate in Power BI, but unable due to SUMIF function not available. General Gist of ...
Managed to resolve it.
Calculation = (CALCULATE(SUMX('Table'[Orders]),FILTER(Table,Table[Period]<>"APR 2016")) + (CALCULATE(SUMX('Table','Table'[Invoiced]),FILTER(Table,Table[Period]="APR 2016"))))
Managed to resolve it.
Calculation = (CALCULATE(SUMX('Table'[Orders]),FILTER(Table,Table[Period]<>"APR 2016")) + (CALCULATE(SUMX('Table','Table'[Invoiced]),FILTER(Table,Table[Period]="APR 2016"))))