How can I create a dynamic list of dates for an axis using measures?

[dehmos27]

I need to create a dynamic list of dates that starts with a date generated by a measure and ends with a date generated by a different measure. I also need to use this list of dates as the axis for a visual.

I thought I’d be able to use CALCULATETABLE, but I keep running into issues when trying to filter the date by the dynamic start and end dates in the measures.

About to pull my hair out, so any help would be profoundly appreciated.

[v-xicai · Accepted solution]

Hi @dehmos27 ,

The measure is not supported to add to the axis of a visual currrently, so you may create a new calculated table, and put the calendar' date column into axis.

Calendar=CALENDAR([Start measure],[End measure])

Best Regards,

Amy

Community Support Team _ Amy

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

[Greg_Deckler]

Measure =

  VAR __Calendar = CALENDAR([Measure1],[Measure2])

RETURN

<some calculation>