Add column and label date as current, previous, and old/blank

[char23]

Hello, I have a set of data in one table I am trying to label. I want to add a new column and label each date as Current, Previous, and Old. I would like to do this in power query if possible, but can use dax if easier. I know I can easily distinguish between current and previous using a max formula with dax. But I want to label anything that is not the previous month as old or blank. 

Table:

Date

7/17/2024

7/17/2024

6/10/2024

6/10/2024

5/12/2024

5/12/2024

New column (Date Status) I want to add:

Date	Date Status
7/17/2024	Current
7/17/2024	Current
6/10/2024	Previous
6/10/2024	Previous
5/12/2024	Old/blank
5/12/2024	Old/blank

[PhilipTreacy · Accepted solution]

Hi @char23 

You can use this code in PQ:

Custom Column

= if Date.IsInCurrentMonth([Date]) then "Current"

else if Date.IsInPreviousMonth([Date]) then "Previous"

else "Old/Blank")

Regards

Phil