Power BI Time Intelligence: Next Month and Previous Month

A Power BI Time Intelligence guide to calculating values for the previous month and the next month, using the DAX functions PREVIOUSMONTH() and NEXTMONTH(). This can also be applied to next or previous DAY, QUARTER and YEAR.

#PowerBI #PracticalBI #BusinessIntelligence

[getright]

It returns error ''A date column containing duplicate dates was specified in the call to function 'PREVIOUSMONTH''

[jimmyxrs]

Do you have the dax to create the calendar table? or a video on it? the previous month measure is returning blank for me (all months not just Jan) but i think its my date table thats causing it as it must be set up differently.

[vidya]

Could you show the previous month and next month measure, only change the previous month value, not previous month name .so please show me the measure

[sunnygawande]

You use slicer for month nd year but if we have date time column then how should we create exactly same filter(slicer) lyk u

[hamzamottali]

Hello, please I have a question .
i calculated a value by measure and I want to display automatically this value in the next month, how can i do that ? i tried nextmonth fucntion but didn't work with me, would you help me please ? for example : I calculated a value in the first month of the year, and I want to show this value in the second month and so on

[nathanvessels]

wait, where did this calendar table come from?

[alexking]

Just what I was looking for. Big thanks!

[charunijhawan]

I see that you didn't use PREVIOUSMONTH or NEXTMONTH function, instead you have used your measures. What is written in those measures ?

[NagaRajuvenkatapuram]

Nice and clear explanation !! keep it up !!