Forum Discussion
Analitika
Post Prodigy
Post ProdigyOne month sales (30 days back) Power BI
Hello, How to calculates one month sales (30 days back) in Power BI?
AnalitikaPost Prodigy
Post ProdigyIs it one month sales?
piotr_gor
Helper II
Helper IIIt's previous month sales.
If you want to calculate last 30 days you could use (thanks to this article) :
30 Days Sales =
VAR NumOfDays = 30
VAR LastCurrentDate =
MAX ( 'Date'[Date] )
VAR Period =
DATESINPERIOD ( 'Date'[Date], LastCurrentDate, - NumOfDays, DAY )
VAR Result =
CALCULATE (
SUMX(
VALUES( Date[Date] ),
[Sales Amount]
),
Period
)
VAR FirstDateInPeriod = MINX ( Period, 'Date'[Date] )
VAR LastDateWithSales = MAX ( Sales[OrderData] )
RETURN
IF ( FirstDateInPeriod <= LastDateWithSales, Result )