DAX-After Data been loaded to the data model and I call calculated the
TotalSale:=([Revenue]) Column which works fine just for me to use the previous measure to calculate the LY
Sale:=Calculate([TotalSale]),Sameperiodlastyear('Calender'([Date]))
The result showing blank. Please help how to go about it.
Thanks!