Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

YTD Cumulative for weekly figures

  I am trying to create measure for the cumulative columes. Below is the DAX code I wrote. As you can see in the last colume of the visual, it is still showing by week numbers not cumulative by week...
Need Help
v-lili6-msft's avatar
v-lili6-msft
Icon for Community Support rankCommunity Support
6 years ago

hi Anonymous 

If so, just remove the conditional "KEEPFILTERS ( 'Table'[Year] = 2020 )" from the measure.

 

Regards,

Lin

Anonymous's avatar
Anonymous
Not applicable
6 years ago

En, we are getting very very close. 

 

After I removed the condition,

 

- The weeks that we have data in 2020 ( 2020 is not over yet), it's showing 2020 instead of 2019 cumulative figures. 

- The weeks that we don't have data in 2020, it is cumulating 2019 weekly numbers to 2020 running total uptil the last week in 2020. 

 

Another observation is that the colume total of 2019 cumulative is now showing the total of 2020 cumulative.

 

Appreciate your help. Wish you safe and healthy amist this unprecedent crisis.

 

Jen

  • v-lili6-msft's avatar
    v-lili6-msft
    Icon for Community Support rankCommunity Support
    6 years ago

    hi  Anonymous 

    For your case, you'd better drag [Year] field into visuals. you need year-weekno dim in the visual.

     

    Regards,

    Lin

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      I can't. The visual is what's been requested. Has to be exactly the same. I can't change the layout. Jen