Need help in DAX Calculation below is my issue
Need to compare each and every date with my Max date in my dataset
i tried below formula but its throwing me error " Expression refer to multiple columns.Multiple columns cannot be converted to scalar value"
any help would be highy appreciated
CALCULATE([Total Revenue],FILTER(‘Date’,‘Date’<= MAXX(‘Date’,‘Date’[Day])&& ‘Date’[Date]>= MAXX(‘Date’,‘Date’[Date])-[TimeFrame Selected Value]))