Forum Discussion

Helper I

8 years ago

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: ...

Tips and Tricks

Anonymous
8 years ago
vishal17081990,

Change %v to the following.

%v = IF(ISBLANK(MAX(tbl_SalesDaily[previousweekofyear])),0,[DIFFERENCE]/MAX(tbl_SalesDaily[previousweekofyear]))

Regards,
Lydia
Anonymous
8 years ago
vishal17081990,

I have sent you PBIX file via Private Message.

Regards,
Lydia

Anonymous

Not applicable

8 years ago

vishal17081990,

I have sent you PBIX file via Private Message.

Regards,
Lydia

Helper I

8 years ago

Hi Lydia,

Anonymous

have gone through it and its wroking fine now.... :)

Cheers,

Vishal.