Forum Discussion
Solved
Weekly %Variance in sales
HI All, I am new to Power Bi and trying to get weekly % Variance in sales figures. tried reading n number of articles on forum and tried, however couldnt resolve, looking forward for your help: ...
vishal17081990,
Change %v to the following.
%v = IF(ISBLANK(MAX(tbl_SalesDaily[previousweekofyear])),0,[DIFFERENCE]/MAX(tbl_SalesDaily[previousweekofyear]))
Regards,
Lydiavishal17081990,
I have sent you PBIX file via Private Message.
Regards,
Lydia
Hi Lydia,
below solution is working fine on total level,
but when i am slicing data on various filters it isnt working.
I have shared PBIX on personal message.
could you please help to advise
Regards,
Vishal.
vishal17081990,
I have sent you PBIX file via Private Message.
Regards,
Lydia
Hi Lydia,
Anonymous
have gone through it and its wroking fine now.... :)
Cheers,
Vishal.