Forum Discussion
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...
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
Helper V
Helper VColumn = IF(MONTH(calender[Date])=MONTH(TODAY()),"Latest","Previous")
is this you are excepting???
Unfortunately i can't use the today function as the dates i'm using are month end dates. So for instance my latest dates in the column are currently 31/12/2022 and 30/11/2022. I would like to mark the December date as "Latest" and the November date as "Previous"
- sudhav
Provide some sample data(by removing sensitive data), so that its easy to get betetr answers..
So i'm trying to achieve this
Month end Month marker 30/09/2022 NA 31/10/2022 NA 30/11/2022 Previous 31/12/2022 Latest