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?
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 )
AnalitikaPost Prodigy
Post ProdigyHow calculate the change of sales comparing with last month in euros and percentage?
- piotr_gor
Check 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 )