previous month sales

[Anonymous]

Dear all,

I am using this formula to find previous month sales

CMSales = CALCULATE(SUM(Dispatch[InvoiceAmount]),FILTER('Calendar','Calendar'[YearMonthnumber]=max('Calendar'[YearMonthnumber])-1))

but i am not getting the result

when i checked 

 test = MAX('Calendar'[YearMonthnumber]) i am getting 201803

but for MAX('Calendar'[YearMonthnumber])-1 i am getting 201.80 but i should get 201802 

pls correct where i am wrong.

Regards,

Joshua.

[Ashish_Mathur]

Hi,

If there is a relationship from the Date column of the Dispatch Table to the Date column of the Calendar Table, then this simple mesure should work

=CALCULATE(SUM(Dispatch[InvoiceAmount]),PREVIOUSMONTH('Calendar'[Date]))

Hope this helps.

[v-cherch-msft · Accepted solution]

Hi @Anonymous

Based on my test, the test measure seems correct. You may check the format for it. You may try to change your CMSales measure as below to get previous month sales.

CMSales =
CALCULATE (
    SUM ( Dispatch[InvoiceAmount] ),
    FILTER (
        ALL ( 'calendar' ),
        'Calendar'[YearMonthnumber]
            = MAX ( 'Calendar'[YearMonthnumber] ) - 1
    )
)

Regards,

Cherie

[PattemManohar]

@Anonymous Please make sure your "YearMonthNumber" is in Number format, if not then try using "VALUE" function in your logic or change the datatype of your "YearMonthNumber" field. 

Might be helpful....