Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Need Help on My Dax

Hi   I need another line for my DAX to cover Cost = 0, Revenue >0 and Comment: Sales But No Cost   I'm having a hard time adding the above condition to the DAX I created below.   //NT   Comme...
Need Help
  • Irwan's avatar
    Irwan
    2 years ago

    Anonymous 

     

    it should be like this, but i am not sure if this works since the previous DAX is not working as you said.

    Column = 

    SWITCH(
    TRUE(),

    'table'[Variance]='table'[Revenue],"Sales But No Cost"
    )

     

    Otherwise please provide you sample data/table or pbix (remove confidential information).

     

    Thank you.

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi,

 

Can you help me to create dax that will make "Sales But No Cost" if both variance and revenue are the same value because it will reference to the same table?

 

I used the dax below but it won' work

'table'[Variance] = table[Revenue]

Irwan's avatar
Irwan
Icon for Super User rankSuper User
2 years ago

Anonymous 

 

it should be like this, but i am not sure if this works since the previous DAX is not working as you said.

Column = 

SWITCH(
TRUE(),

'table'[Variance]='table'[Revenue],"Sales But No Cost"
)

 

Otherwise please provide you sample data/table or pbix (remove confidential information).

 

Thank you.