Power Query

[Narenthir]

Hi,

Below pic from excel, the similar way i want to do in power bi, spceific date before need to reflect as (base) after the dates should be reflect as (After). Help needed thank in advance.

[ChielFaber · Accepted solution]

When you use a specific date you can use a hardcoded date. For this you can create a custom column with the folloewing if statement and the #date function:

if [Date] < #date(2023, 3, 1) then "Base" else "After".

The #date function It works like: #date(year, month,day).

When you need a dynamic date you can replace the #date function and its content with a dynamic function like Date.AddDays , Date.AddMonths, Date.AddYears when you substract a number of days/months/years from a given date.

For example:

if [Date] < 

Date.From(Date.AddMonths(DateTime.LocalNow(),-6))

then "Base" else "After".

You will need to wrap the Data.AddMonths function in a Date.From because Date.AddMonths returns a datetime instead of a date and comparing a date  with a datetime will result in an error.

[Narenthir]

Thanks @ChielFaber solution works