Forum Discussion

D1ltang's avatar
D1ltang
Frequent Visitor
8 years ago

calculate dates between two measures

Hi I have 2 simple measure. One takes the selections on the slicers into account and creates a date. The other uses this newly created date to work out the 1st of the month a year ago. These both wor...
Need Help
v-yulgu-msft's avatar
v-yulgu-msft
Microsoft Employee
8 years ago

Hi D1ltang,

 

You could try to create a calendar table, then, filter this calendar table with the two measures [SelectedDate] and [SelectedDateMinus12] to get the list of dates between specific date range.

 

For more advice, please provide sample data of source table so that we can test.

 

Regards,

Yuliana Gu