Custom Time Frame

Hi Anonymous ,

thank you for the interesting question. You can do all of this with Power Query.

Here are the steps:

1) Unpivot the columns $, Units and Volume (you can do it via the Power Query Unpivot button).

Here is the result

2) Pivot the Time Frame column. You should choose 'Value' for the values column. Here is the result

3) Add a custom column calculated as LS52 minus BTS. You can do that by clicking on Add Column -> Custom Column

then enter the formula: [L52W]-[BTS]

Here is the result

4) Unpivot the columns "ls52w", "bts" and "ls52 minus bts"

5) Pivot the column Attribute

That's it. Here is your final result:

Does this help you?

Let me know if you have more questions.

LC

Interested in Power BI and DAX tutorials? Check out my blog at www.finance-bi.com