Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
Hello,
How to calculates one month sales (30 days back) in Power BI?
CALCULATE ( [Sales Amount], PREVIOUSMONTH ( 'Date'[Date] ) )
Is it one month sales?
It'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 )
How calculate the change of sales comparing with last month in euros and percentage?
Check out your's next topic. I've already answered it.
How calculate average one month sales (30 days back)?
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 )
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
Do you have separate Date table?
Yes
User | Count |
---|---|
132 | |
74 | |
70 | |
58 | |
54 |
User | Count |
---|---|
192 | |
96 | |
67 | |
64 | |
54 |