Forum Discussion

Maikeru's avatar
Maikeru
Helper II
7 years ago
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 ...
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    7 years ago

    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's avatar
Ashish_Mathur
Super User
7 years ago

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.

kcpelesa1's avatar
kcpelesa1
New Member
5 years ago

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.

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Super User
    5 years ago

    Hi,

    Switch to a matrix visual and in the formatting pane, under the Values group, turn on Show on rows.