Forum Discussion

jaco1951's avatar
jaco1951
Icon for Helper III rankHelper III
8 years ago
Solved

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-msft's avatar
    v-yulgu-msft
    Icon for Microsoft Employee rankMicrosoft 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