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 Ashish_Mathur , is it possible have this as a column?
im saying this because im using a Matrix table so it doesnt allow measures in the rows.
Hi,
Switch to a matrix visual and in the formatting pane, under the Values group, turn on Show on rows.