Forum Discussion
Rolling Date Range - X-Axis
Hello, I have a datasource (My Y-Axis) that gives me 52 weeks, it is refreshed once a week with new data and the trims the last week. EX: (Data shows: 4/19/2022 to 4/19/2023 this week, next week 4/26...
Hi
Hello, Yes I was wondering if you knew of a simple way to make the line chart just capture day from 'today() and 52 weeks before rather than have to do all this M script and offset dates and such.
X-Axis: Completion Date (means the date the job was completed on)
Y-AXIS: Job Order Measure = count(Merge1[scheduled_completion_date])+0