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
D1ltang's avatar
D1ltang
Frequent Visitor
8 years ago

Hi Abduvali

 

Thank you for taking the time to respond.

 

Unfortunately the start and end dates that I am using are not static. They are generated as a result of the users input via slicer selection. This solution would be perfect if I could pass my two measures as the Start and End Date in your calendar calculation.

 

Have you got any other suggestions?

 

The final Visual is what I am trying to achieve

 

Thanks again,

 

Dil

Abduvali's avatar
Abduvali
Skilled Sharer
8 years ago

D1ltang

 

 

Can you make a better and bigger screenshot :) cant see anything on this one and please include a screenshot of your table with a Date column.

 

Thanks