Forum Discussion
Pull previous week dimensions in chart
Hi
I have a data set where half of the data is frequently updated while the other half is updated by the end of each week.
When I select the current week I have created a measure that combines the sum of current week for one half of the data, and previous current week on the other half.
This works ecellent as a card or KPI, but as soon as I have a chart with the dimensions added to it, the dimensions related to previous current week will not show up as they do not exist yet.
How can I create a calculated dimension that will use previous week dimension in a chart?
Thank you.
Br Espen
Hi jaco1951,
You could try to create an extra dimention table related to your data table to list all available dates and weeks.
Regards,
Yuliana Gu
1 Reply
- v-yulgu-msftMicrosoft Employee
Hi jaco1951,
You could try to create an extra dimention table related to your data table to list all available dates and weeks.
Regards,
Yuliana Gu