Forum Discussion
Solved
Calculating Min/Max date columns based on selected values
Hi, I am trying to insert 2 new columns into my dataset containing the MIN/MAX values of the date slicer. I was thinking about the following DAX, but it throws me a circular dependency ...
Hi,
You have to write measures, not calculated column formulas. Delete all column from the Calendar Table except the Date column. Write these measures
Minimum date = CALCULATE(MIN('Calendar'[Date]),ALLSELECTED('Calendar'[Date]))
Maximum date = CALCULATE(MAX('Calendar'[Date]),ALLSELECTED('Calendar'[Date]))
Hope this helps.
Hi,
You have to write measures, not calculated column formulas. Delete all column from the Calendar Table except the Date column. Write these measures
Minimum date = CALCULATE(MIN('Calendar'[Date]),ALLSELECTED('Calendar'[Date]))
Maximum date = CALCULATE(MAX('Calendar'[Date]),ALLSELECTED('Calendar'[Date]))
Hope this helps.
Thank you Ashish_Mathur!
That's exactly what I was looking for!
You are welcome.