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
Anonymous's avatar
Anonymous
Not applicable
6 years ago

I need both years side by side. Slider is more interactive. Jen

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