Calculate Previous MTH

[AvGonzalez]

Hello!!

I have a problem when calculating the previous month of total sales.

The formulas I use are the following.

Total Units = SUM('BD'[Sales Units])

Previous MTH = CALCULATE([Total Units], DATEADD('BD'[Period],-1,MONTH))

and it gives me this problem.

Data Base & Power Bi File 

I suspect it's a problem with my database, but I can't find if it's a format issue or how the data is contaminated.
can someone help me :c

[marcelsmaglhaes]

Hey @AvGonzalez ,

If my post helps,pPlease consider Accept it as the solution to help the other members find it more quickly.

Kind regards
Marcel

[marcelsmaglhaes · Accepted solution]

Hey @AvGonzalez ,

You can try change your DAX like below:

Previous MTH = CALCULATE([Total Units], PREVIOUSMONTH('FullMarket Venezuela'[Period].[Date]))

*If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Kind Regards,
Marcel Magalhães

[AvGonzalez]

Thank you very much, changing my code like that fixed all the problem, thank you 😄

[amitchandak]

@AvGonzalez , You should always use date table joined to date of your table in such cases

example

Month behind Sales = CALCULATE(SUM(Sales[Sales Amount]),dateadd('Date'[Date],-1,Month))

Why Time Intelligence Fails - Powerbi 5 Savior Steps for TI :https://youtu.be/OBf0rjpp5Hw
https://amitchandak.medium.com/power-bi-5-key-points-to-make-time-intelligence-successful-bd52912a5b...

Time Intelligence, Part of learn Power BI https://youtu.be/cN8AO3_vmlY?t=27510
Time Intelligence, DATESMTD, DATESQTD, DATESYTD, Week On Week, Week Till Date, Custom Period on Period,
Custom Period till date: https://youtu.be/aU2aKbnHuWs&t=145s