Summry Tables but showing only 12 Weeks

[ElieK]

Hello,

I am trying to get a summary table in DAX that gives our Average Handle Time for the first 12 weeks of our agents time after they finish their training.

Based on the data I haveI can build a summary table, but I cant figure out how to dynamicly show show the first 12 weeks after their Training End Date

Ideal output would look like:

Start Date  Week1 Week2 ... Week12
31-MAR-19  19.90 18.72 ... 14.73
25-AUG-19  15.67 14.83 ... 13.77
04-JUN-20  15.98 15.98 ... 11.52
21-MAR-21  21.95 20.51 ... 

What I keep getting is

Start Date  31-MAR-19 07-APR-19 ... 16-JUN-19  ... 25-AUG-19  01-SEP-19  ...
31-MAR-19   19.90     18.72     ... 14.73
25-AUG-19                                          16.83    16.70
04-JUN-20
21-MAR-21

With the later hire dates having values further down.

Is there a way to have PowerBI align the Start Dates as Week 1 (And maybe add a Week 1 - Week 12 lables based on the start date?)

[MFelix · Accepted solution]

Hi @ElieK ,

For this you need to create an additional table that gets the ordering of the weeks.

I have made a blog post about making a similar use of this based on the start date of a store, please check the blog post below, it's in Portuguese but you can use the google translate that will work.

https://pbiportugal.com/2021/05/26/comparar-n-mes-vendas/

If you need any assistance please tell me and if you can please share a mockup data or sample of your PBIX file. You can use a onedrive, google drive, we transfer or similar link to upload your files.

If the information is sensitive please share it trough private message.

[ElieK]

Thanks @MFelix This worked with exactly what I wanted to see!