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 ProdigyHow calculate the change of sales comparing with last month in euros and percentage?
piotr_gor
Helper II
Helper IICheck out your's next topic. I've already answered it.
- Analitika
How calculate average one month sales (30 days back)?
- piotr_gor
30 Days Sales =
VAR NumOfDays = 30
VAR LastCurrentDate =
MAX ( 'Date'[Date] )
VAR Period =
DATESINPERIOD ( 'Date'[Date], LastCurrentDate, - NumOfDays, DAY )
VAR Result =
CALCULATE (
AVERAGEX(
VALUES( Date[Date] ),
[Sales Amount]
),
Period
)
VAR FirstDateInPeriod = MINX ( Period, 'Date'[Date] )
VAR LastDateWithSales = MAX ( Sales[OrderData] )
RETURN
IF ( FirstDateInPeriod <= LastDateWithSales, Result )- Analitika
The syntax for '[Date]' is incorrect. (DAX( VAR NumOfDays = 30 VAR LastCurrentDate = MAX ( 'Date'[Date] ) VAR Period = DATESINPERIOD ( 'Date'[Date], LastCurrentDate, - NumOfDays, DAY ) VAR Result = CALCULATE ( AVERAGEX( VALUES( Date[Date] ), [P