Rolling Date Range - X-Axis

[TylerVono]

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/2022 to 4/26/2023).

I had to also develop a Date Table as well  to weave in the Y axis results.

I would like to have a automatic adjustment of the range just showing the MIN and MAX added to show on the visual, rather than a manual range entered:

The Line Graph:

x-axis: Scheduled Completion Date of a Date Table

Y Axis: 

Job Order Measure = count(Merge1[scheduled_completion_date])+0

Are there any good DAX to use so the date ranges change with the new data refreshes?

[Anonymous]

Hi @TylerVono 

You can create  measures

Measure=min('table'[Date')
Measure=max('table'[Date')

Then put them to the range

Best Regards!

Yolo Zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[TylerVono]

Hello Yolo Zhu,

 So it did not work, I cannot add the measure to the range.

This is my option:

The measure falls under my Tooltips:

Any other options? Min and Max measures not working.

[Anonymous]

Hi

[TylerVono]

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