I am new to DAX. Below is my code:
var maxdate = MAX((DATEADD(DimDate[Date], -1 , month)))
From research, DATEADD returns A table containing a single column of date values.
However, I get the following error when I try to save the measure "The MAX function only accepts a column reference as an argument." What is the name of the column in the table return by DATEADD so I can reference it?
Hello Anonymous
Instead of MAX try it with LASTDATE, should give you what you are looking for.
VAR maxdate = LASTDATE ( DATEADD ( DimDate[Date],-1, MONTH ) )
Super UserHello Anonymous
Instead of MAX try it with LASTDATE, should give you what you are looking for.
VAR maxdate = LASTDATE ( DATEADD ( DimDate[Date],-1, MONTH ) )
Super UserThe above solution or you can try
maxx('DimDate',DATEDIFF('DimDate'[Date],-1,MONTH))Thanks amitchandak and jdbuchanan71 for your help :smileyhappy: