Forum Discussion

danextian's avatar
danextian
Icon for Super User rankSuper User
9 years ago
Solved

MAX showing incorrect value

Hi,   I find this weird but I may be doing it wrong.   Basically, what I am trying to accomplish is get the max date in the date table which is filtered to start from 1/1/17 until date today (don...
Need Help
  • danextian's avatar
    danextian
    9 years ago

    MFelix

     

    Thanks for the response but as mentioned, my calendar table's maximum value is the current date so it should be 7/18.

    But I've figured out where I went wrong. By adding a .[Date] after Calendar[Date], the measure uses the hidden table created by PBI desktop's time intelligence featture.  Removing  .[Date] solves the problem. 

MFelix's avatar
MFelix
Icon for Super User rankSuper User
9 years ago

Hi danextian,

 

The question is that you are using the ALL and by doing that you discard all the filter you have on the Calendar date and return the maximum value of the full table ignoring all the rest of the filters you need to do something like this:

 

MaxDate with Calculatte ALLSELECTED =
CALCULATE ( MAX ( Calendar[Date] ), ALLSELECTED ( 'Calendar'[Date] ) )

As you can see below I have made a print with your two formulas and mine with a slicer see the result:

 

 

Regards,

Mfelix

danextian's avatar
danextian
Icon for Super User rankSuper User
9 years ago

MFelix

 

Thanks for the response but as mentioned, my calendar table's maximum value is the current date so it should be 7/18.

But I've figured out where I went wrong. By adding a .[Date] after Calendar[Date], the measure uses the hidden table created by PBI desktop's time intelligence featture.  Removing  .[Date] solves the problem. 

  • v-yulgu-msft's avatar
    v-yulgu-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    9 years ago

    Hi danextian,

     

    Thanks for your sharing. Please kindly mark the corresponding resolution as an answer so that it can benefit more users.

     

    Thanks,

    Yuliana Gu

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Thanks danextian . Sometimes a big problem can be solved with simple solutions. Your suggestion here made my day peaceful.

    • danextian's avatar
      danextian
      Icon for Super User rankSuper User
      6 years ago

      Hi Anonymous ,

      This was from my early DAX days when I was  still a newbie and not yet a super user.