dax

[Anonymous]

i want to show current month sales, last month sales, average of last 3 months, average of last 6 months, last year same month sales in a matrix. also i want to do it through a date range like 1 to 6 or 1 to 31. 
i have seperate date table and that is mapped with my main sales file.

[VijayP · Accepted solution]

@Anonymous 

DateADD for last month

averagex and dateadd for other two options

sameperiod last year for last requirement

These dax will help you!

Just asking plain text will not help people to help you! you need to do some ground work before asking question in this forum