Forum Discussion
Solved
An argument of function 'DATE' has the wrong data type...
I know there are heaps of similar posts and I promise I've tried different solutions, but for the life of me, I can't work out what I'm doing wrong. I'm attempting to calculate the increase in me...
HChoice , I am assuming Quarter Ending has datatype date and if so measure looks correct.
Need to check what you are adding to visual, because max will work on row context
you can try
VAR mdate = MAXX(allselected('Quarterly Rent') , 'Quarterly Rent'[Quarter Ending])
amitchandak
Super User
Super UserHChoice , I am assuming Quarter Ending has datatype date and if so measure looks correct.
Need to check what you are adding to visual, because max will work on row context
you can try
VAR mdate = MAXX(allselected('Quarterly Rent') , 'Quarterly Rent'[Quarter Ending])
Thank you!! Sorry for the exceptionally late reply. I'm not entirely sure why it works, but I'll take it.