Forum Discussion

vishal17081990's avatar
vishal17081990
Icon for Helper I rankHelper 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: ...
Need Help
Tips and Tricks
  • Anonymous's avatar
    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's avatar
    Anonymous
    8 years ago

    vishal17081990,

    I have sent you PBIX file via Private Message.

    Regards,
    Lydia

vishal17081990's avatar
vishal17081990
Icon for Helper I rankHelper I
8 years ago

Anonymous

Shared in personal message.. :)

Anonymous's avatar
Anonymous
Not applicable
8 years ago

vishal17081990,

I sent you PBIX file via Private message. Please check if you get expected result.



Regards,
Lydia

  • vishal17081990's avatar
    vishal17081990
    Icon for Helper I rankHelper I
    8 years ago

    Anonymous

     

    There is something wrong with the %v calculation.

    i have dropped you an personal message.

     

     

     

    Regards,

    Vishal.

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      vishal17081990,

      Change %v to the following.

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



      Regards,
      Lydia

      • vishal17081990's avatar
        vishal17081990
        Icon for Helper I rankHelper I
        8 years ago

        Hi Lydia,

        Anonymous

         

        that looks perfect... :)

         

        Thanks a ton for the solution...

         

        Cheers,

        Vishal.