Forum Discussion
Need Help on My Dax
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.
Hi,
It still doesn't work. I guess because the cost data came from a different table...
Super Userhello Anonymous
the conditional if looks like only calculate those values (Revenue, Cost, and Variance), so the source dont affect much as long as you have value in those column.
Otherwise, if you dont mind, please provide your sample data in pbix (remove the confidential information) so we can work it out.
Thank you.
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
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.
Hi,Anonymous
Can you tell me if your problem is solved? If yes, please accept it as solution.
Best Regards,
Leroy Lu