Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Rolling Snapshot Line Chart

I am just learning DAX, and am having trouble with a request at work. I have read some similar posts but still having trouble understanding it to make my own. The topic is creating a Rolling snapshot...
Date
DAX
Help Requested
WinterMist's avatar
WinterMist
Icon for Impactful Individual rankImpactful Individual
4 years ago

Anonymous 

 

Additional Notes:

- Calculated Columns are only re-calculated on refresh.

- As long as you have the report set to auto-refresh daily, the rolling time-frame will function properly.

 

For example, I refreshed the report this morning, and can now see that 7/21/2022 is correctly included in both Line Charts for today.

 

Regards,

Nathan

 

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Thank you, this is definitely a helpful starting point. I do have a few extra notes.

     

    Doing it this way is rolling forward by day. What if I wanted it to only shift one business week at a time? Let's say I consider my week as Monday- Sunday. When Monday comes along, we want the chart to show the dates for that Monday all the way through Sunday. 

    My next question is if I want to Sum by Week. And have the rolling shift Monthly. 

     

    Regards, 
    Ian