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,
It fetches the first and last date selected in the slicer.
What I meant to understand is what the ALLSELECTED doing inside the CALCULATE function.
Is it always good to use ALLSELECTED while working with dates?