Forum Discussion

danextian's avatar
danextian
Super 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. 

danextian's avatar
danextian
Super 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
Microsoft 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