Previous month but something is off

[Anonymous]

Hi Power BI Community!

I want to show the last completed month. I tried these formulars. The first comes very close but it shows not the last month at the beginning.

Previous month = CALCULATE([Count of delivery note], PREVIOUSMONTH(Dates[Date]))

Last months = CALCULATE(COUNT(TrackET[Delivery note])+0, DATESINPERIOD(Dates[Date2], MAX(Dates[Date2]), -1, MONTH))

[amitchandak · Accepted solution]

@Anonymous , what is the issue ? the first formula and one I am sharing should work with a date table. Marked as date Table. Make sure Date table is Marked as date Table

Previous month = CALCULATE([Count of delivery note] , PREVIOUSMONTH(Dates[Date]))

last MTD (complete) Sales = CALCULATE(SUM([Count of delivery note] ,DATESMTD(ENDOFMONTH(dateadd('Date'[Date],-1,MONTH))))

[Anonymous]

Thanks now it works!