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.

KShro's avatar
KShro
New Member
2 years ago

Hi,

What are the min and max date codes doing and when to use it?

Appreciate your explanation.

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Super User
    2 years ago

    Hi,

    It fetches the first and last date selected in the slicer.

    • KShro's avatar
      KShro
      New Member
      2 years ago

      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?