Forum Discussion
danextian
Super User
Super UserMAX 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...
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.
