Latest month and latest month -1 DAX

[Anonymous]

Hi guys, I want a calculated column next to my date column which would indicate the latest Date(specifically month) in the column and bring "Latest Month" and also would indicate -1 month from "Latest Month"  and bring it as "Previous Month". The rest is blank. Example:

I have written a dax but it gives me all blanks..

Month =

var Latest_month = MAX('Portfolio status'[Date])

var Previous_month = Latest_month-1

return

IF('Portfolio status'[Date]=Latest_month, "Latest Month", IF('Portfolio status'[Date]=Previous_month, "Previous Month"))

[Fowmy · Accepted solution]

@Anonymous 

Try this, minor chagne, I replaced today with the max

Month = 

var _CurrMonth = MAX('Portfolio status'[Date]) 
var _CurrDate= 'Portfolio status'[Date]
return
IF( FORMAT(_CurrDate,"yyyymm") = FORMAT(_CurrMonth,"yyyymm"), "CURRENT",
    IF( FORMAT(_CurrDate,"yyyymm") = FORMAT(EOMONTH(_CurrMonth,-1),"yyyymm"), "PREVIOUS")
) 

________________________

If my answer was helpful, please consider Accept it as the solution to help the other members find it

Click on the Thumbs-Up icon if you like this reply 🙂

YouTube  LinkedIn

[Fowmy]

@Anonymous 

Add this code as a new column to your table:

Month = 
var _CurrMonth = TODAY() 
var _CurrDate= 'Portfolio status'[Date]
return
IF( FORMAT(_CurrDate,"yyyymm") = FORMAT(_CurrMonth,"yyyymm"), "CURRENT",
    IF( FORMAT(_CurrDate,"yyyymm") = FORMAT(EOMONTH(_CurrMonth,-1),"yyyymm"), "PREVIOUS")
) 

________________________

If my answer was helpful, please consider Accept it as the solution to help the other members find it

Click on the Thumbs-Up icon if you like this reply 🙂

YouTube  LinkedIn

[Anonymous]

Ok, @Fowmy , today() is not suitable for me, as latest date may be with the huge delay, please see my screenshot. That is the exact dates I have now.

[Anonymous]

@Fowmy , thanks for prompt reply but it only gives me "PREVIOUS" values and rest is blank.