Forum Discussion

nnouchi's avatar
nnouchi
Icon for Helper I rankHelper I
6 years ago
Solved

Excel to Dax, using sumifs formula

I'm in process of converting an excel report to Power BI. This includes matching the output of a column that has a SUMIFS formula included in the conditional statement.   The columns are exactly th...
conditional columns
Filter
sumifs
Sumx()
  • Anonymous's avatar
    Anonymous
    6 years ago

    Hi nnouchi ,

     

    Try this Calculated Column


    Column =
    SWITCH(
    TRUE(),

    'Sales'[Shipped/CSO] = "Shipped", 0,

    SUMX(FILTER(Sales,Sales[InvoiceDate]=EARLIER(Sales[InvoiceDate])&& Sales[Branch]=EARLIER(Sales[Branch]) && Sales[Part] = EARLIER(Sales[Part]),Sales[QTY]))

    )

     

    Regards,

    Harsh Nathani

    Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi nnouchi ,

 

Try this Calculated Column


Column =
SWITCH(
TRUE(),

'Sales'[Shipped/CSO] = "Shipped", 0,

SUMX(FILTER(Sales,Sales[InvoiceDate]=EARLIER(Sales[InvoiceDate])&& Sales[Branch]=EARLIER(Sales[Branch]) && Sales[Part] = EARLIER(Sales[Part]),Sales[QTY]))

)

 

Regards,

Harsh Nathani

Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)

nnouchi's avatar
nnouchi
Icon for Helper I rankHelper I
6 years ago

Harsh,

 

The result is the same, which is making me question whether the difference between indexes is causing the difference in output. 

 

I believe this is the correct answer, so I will be accepting this for the thread.

Thank you for your efforts.

 

Nicolas