One month sales (30 days back) Power BI

[Analitika]

Hello,

How to calculates one month sales (30 days back) in Power BI?

[piotr_gor]

CALCULATE ( [Sales Amount], PREVIOUSMONTH ( 'Date'[Date] ) )

[Analitika]

Is it one month sales?

[piotr_gor]

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 )

[Analitika]

How 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 )

[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

[piotr_gor]

Do you have separate Date table? 

[Analitika]

Yes