Forum Discussion

stokesmcr's avatar
stokesmcr
New Member
10 years ago
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 ...
Need Help
Tutorial Requests
  • stokesmcr's avatar
    stokesmcr
    10 years ago

    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"))))

GilesWalker's avatar
GilesWalker
Skilled Sharer
10 years ago

stokesmcr - had this same issue the other day. This worked for me:

 

CALCULATE(SUMX('Table','Table'[Invoiced goods]+[Ordered goods]),FILTER(ALL('Table'),'Table'[Period]<=MAX('Table'[Period])))

 

Thanks should work for you. 'Table' is what ever your table/file name is.

 

Thanks,

 

Giles

stokesmcr's avatar
stokesmcr
New Member
10 years ago

GilesWalker

 

Thanks for your help so far. How did you pass the time period requirement into the formula?

 

In my case - I want "Invoiced" for April and "Orders" for May + June. 

 

Thank you, Michael