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

     

     

sudhav's avatar
sudhav
Icon for Helper V rankHelper V
3 years ago

Provide some sample data(by removing sensitive data), so that its easy to get betetr answers..

Anonymous's avatar
Anonymous
Not applicable
3 years ago

So i'm trying to achieve this

 

Month endMonth marker
30/09/2022NA
31/10/2022NA
30/11/2022Previous
31/12/2022Latest
  • Manoj_Nair's avatar
    Manoj_Nair
    Icon for Solution Supplier rankSolution Supplier
    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