Forum Discussion
Maikeru
Helper II
Helper IICalculating 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.
Ashish_Mathur
Super User
Super UserHi,
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.
MaikeruHelper II
Helper IIThank you Ashish_Mathur!
That's exactly what I was looking for!
- Ashish_Mathur
You are welcome.