Forum Discussion

char23's avatar
char23
Helper II
2 years ago
Solved

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

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:

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

 

Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • PhilipTreacy's avatar
    PhilipTreacy
    2 years ago

    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

1 Reply

  • PhilipTreacy's avatar
    PhilipTreacy
    Super User
    2 years ago

    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