Forum Discussion
Solved
Help needed in dax expression - for Conditional Formating for background color.
Hi All, Help needed for Conditional Formating for background color. My requirement : =if(Len([PTD - Revenue Accrual (Ex-GST)])>0 and [PTD - Revenue Accrual (Ex-GST)]<>'-', if([PTD - Reve...
Thanks for the help..
PTD - Revenue Accrual Color = SWITCH( TRUE(), AND( LEN([PTD - Revenue Accrual(Ex-GST)]) > 0, [PTD - Revenue Accrual(Ex-GST)] <> BLANK() ), IF( [PTD - Revenue Accrual(Ex-GST)] > ([MTD Total - Revenue(Ex-GST)] * 0.3), "#FFC7CE" // This is a hex color code for a shade of red ), BLANK() )instead of "-" I used Blank()
hello ashmitp869
you use RETURN when you are using VAR.
if there is no VAR in prior to, then no need to put RETURN.
Thank you.