Forum Discussion
Solved
My expression return wrong value ( This expression is working fine in Sales Table )
Hi All _Below expression look okay , But it return wrong % :- _Vari_%_NP = if(isblank( divide( [_YTD_NP_SGD] - [_LYTD_NP_SGD] , [_LYTD_NP_SGD] )),1, divide( [_YTD_NP_SGD] - [_LYTD_NP...
Hi admin11 ,
Here are the steps you can follow：
1. Create measure
Measure 4 = IF( CONTAINSSTRING([Vari_%_NP yang_liu],"- ve%"),1,0)2. Select [Vari_%_NP yang_liu], select Conditional formatting – Background color
3. Enter the Background color interface, select Format by-Rules, Based on field-Measure4, set the conditions
4. Result.
You can downloaded PBIX file from here.
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
admin11 , As per your formula this number is correct. (YTD- LYTD)/LYTD
Spoiler
As in most of the time , in the past LYTD never have -ve value. But this time it have -ve value.
Can you pls advise me how to modify the expression , so that when LYTD -ve value and YTD value +ve , it will return +ve % ?
Paul Yeo