Profits 30D MA =
AverageX(
DATESINPERIOD(
Dates[Date],
MAX(Dates[Date]),
-30,
DAY),
//Use Total Measure
[Total Profits]
)
Last Transaction Date
Last Transaction Date =
LASTNONBLANK(Dates[Date], [Total Sales])
Cumulative Sales LQ
Cumulative Sales LQ =
//Using Measure Sales LQ
Calculate ([Sales LQ],
Filter(AllSelected(Dates),
Dates[Date] <= Max(Dates[Date])))
Cumulative Sales LM
Cumulative Sales LM =
//Using Measure Sales LM
Calculate ([Sales LM],
Filter(AllSelected(Dates),
Dates[Date] <= Max(Dates[Date])))
Cumlative Sales LY
Cumulative Sales LY =
//Using Measure Sales LY
Calculate ([Sales LY],
Filter(AllSelected(Dates),
Dates[Date] <= Max(Dates[Date])))
First Date
First Date =
Min Date = (Min(‘Dates’)[Date])
Last Date
Max Date = (Max(‘Dates’)[Date])
SALES LM
SALES LM =
Calculate([Total Sales],
DATEADD(Dates[DATE], -1, Month))
Sales LQ
Sales LQ =
Calculate([Total Sales],
DATEADD(Dates[DATE], -1, Quarter))
Cumulative Sales
Cumulative Sales =
Calculate ([Total Sales],
Filter(AllSelected(Dates),
Dates[Date] <= Max(Dates[Date])))
My Collection 