How to create a table that presents current and previous month data.

[deanbland]

Hi, 

I am trying to create a table that compares the current months DAIs with the previous months. Example given below: 

I am wanting the data to actively change - so when it's October the previous months is September and when the Current month turns to November, the previous month will change to October. 

Thanks, 

Dean

[jaideepnema · Accepted solution]

@deanbland please create the following two measures....here is the DAX Code

Current Month RAG = CALCULATE(FIRSTNONBLANK('Table'[RAG Status],TRUE()),FILTER('Table',MONTH('Table'[Report Date])=MONTH(TODAY())))

Previous Month RAG = CALCULATE(FIRSTNONBLANK('Table'[RAG Status],TRUE()),FILTER(ALLEXCEPT('Table','Table'[DAI]),MONTH('Table'[Report Date])=MONTH(TODAY())-1))

This will give you the required output as shown below

Please accept this as a solution if this resolved your query !! Appeciate a Kudos also 😀 

[deanbland]

Works a treat, thank you!

[lbendlin]

Have you tried using DateAdd(...-1,Month)  or EDATE(-1)  in your DAX?

[deanbland]

Unsure how to action this... I am relitively new to Power BI! 

I have produced a mock-up table below, what would the DAX formula be/ what steps would I need to carry out? 

The ideal scenario would be to add a column that shows as true or false (true when the date is one month ago and false for any other date).