Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Create Latest and previous month marker

Hi   I'm trying to solve what i think should be a pretty simple problem, but it's beating me!   I'm trying to create a calculated column which basically returns whether a date is the "latest" mon...
Need Help
  • Manoj_Nair's avatar
    Manoj_Nair
    3 years ago

    Anonymous 

    Try this code - I just tweaked your original code, but you need to add one more calculated column called PrevMonth. Check this out.

    1. 

     

    Prev Month = PREVIOUSMONTH(Date_table[Month_end])

     

    2.

     

    Month Marker = if(Date_table[Month_end] = MAX(Date_table[Month_end]), "Latest", if(Date_table[Month_end] = max(Date_table[Prev Month]), "Previous","NA"))

     

     

    Let me know if this works for you. Many Thanks

     

     

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Manoj_Nair  many thanks. I'd actually tried this previously and it didn't work, but clearly i'd made a mistake somewhere and on second go it works perfectly!