Forum Discussion

jaco1951's avatar
jaco1951
Helper 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
    Microsoft 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