Current Month and Previous Month Total | Power BI | Advanced DAX

Get the month and year separately and compare it with the calendar for getting total for current and previous month.

Full set of Tutorials for Power BI
---------------------------------------------------
Introduction to Power BI (videos)

Power Query (videos)

DAX (videos)

Visualization (videos)

Service (videos)

Interview Questions (videos)
__________________________________________________________________________________
Kindly like, subscribe and share among Power BI aspirants

[YungJacques]

Very useful - this helped way more than the last 3 videos I watched! Thanks!!!

[legopspfreak]

YOU ARE THE BEST! I have been trying ways to get my data to explain CM and PM and you helped me do it concisely and quickly.

[channic]

Thanks for your video. It is very helpful and workable for me.

[irfanqadri]

Maestro. Amazing. Thank You. I was hoping from the thumbnail about last week too sir.😊

[rajeshnkashyp]

It's very helpful. thanks a lot!!

[josedanielisidororeyes]

This is what I was looking for. After trying various methods provided in PowerBI forums, this solved my problem. Thanks

[kommabalaji]

Bro your explaination is nice concept is excellent, but only drawback is when you are explaininig the DAX formula you are going bit speed. If you reduce the speed, and take somemore time to explain the code. Especially previous month. It will be excellent. Please make some more DAX advanced Realtime scenarios

[AshwameghPotpelwar-ck]

i have implemented this thing but when i am applying filter of r 1 month the previous month should show the previous value but its not showing it coming up blank ....any suggestion

[betosfilm]

is there any relationship between the calendar table and your sales details table? or how did were able to visualize fields from both sources in one single table on min 1:29

[JordanFalcon-hq]

The Previous Month code works, however it doesn't display on the visual card that I am trying. Please can you explain/support/advise further

[jaymajor]

My Previous month card comes up hlank, any help with this

[mobitheman]

Hi BroRaj, how can I put these 2 measures in one stacked column?

[Oracle]

It helped, but when I added a date slicer, the last month measure goes blank.

[yasirkhaleeque]

Thanks for the video. What about I want the same calculation for a month and month before. In your example, you picked the latest month, but what if I want to perform same calculation for other months as well.

[fahmywaleed]

Explaining at the speed of light is hard to keep up with, try to pause and explain what you are doing. thanks for the video though

[sweetyranbhor]

Plzz help me with scenario that i want current month sale, previous month sale and last year sale

[jayaprakash-bmws]

Hi bro, thanks for the video, it helps me a lot.can you please explain how to show current month name and previous month name in kpi cards

[EspiritoemFoco]

Cê é bão de mais no que ce faiz meu brodim, salvou o papai, o unico problema é q ce criou um sistema pra resolver essa merda, mas tamo junto, depois em como resolver mais fácil