Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

How to sum the values

Hi Experts,   I have the Actual table and Plan table, I have appended the tables and created new table.   The problem is, i have period in Actual table but not in Plan, so what i have done is I j...
Need Help
Anonymous's avatar
Anonymous
Not applicable
7 years ago

 

In the above, if I select a value as 1 in the slicer, it should calculate the plan. but if you see the period as 1 the plan is 0. hope you can understand. if I select slicer value as "1", then it should calculate the selected value + Period = 0  values as well.

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi All,

 

Any luck?!

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    HI Anonymous ,

    You can do unpivot column to actual and plan fields, then you can write a formula to summary them based on category fields.

    Unpivot columns (Power Query)

    Regards,

    Xiaoxin Sheng