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

Anonymous's avatar
Anonymous
Not applicable
8 years ago

vishal17081990,


Create the following column in your table.

previousweekofyear = CALCULATE(SUM(Table[Staples]),FILTER(Table,Table[TYWN]=EARLIER(Table[TYWN])&&Table[tbl_Calendar.TYN]=EARLIER(Table[tbl_Calendar.TYN])-1))


Then create the following measures in your  table and check if you get expected result.

DIFFERENCE = SUM(Table[Staples])-MAX(Table[previousweekofyear])
%v = [DIFFERENCE]/SUM(Table[Staples])

There is an example for your reference.



Regards,
Lydia

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    vishal17081990,

    I am unable to view any data when opening this PBIT file. Could you please share 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