Solved: Re: Power Query Date

HenryJS · ‎05-26-2021

Hi all,

How can I create a custom column in power query that states:

IF [date] is greater than today and less than today +3 months THEN yes

Thanks

Fowmy · ‎05-26-2021

@HenryJS

Add the following as a custom column:

= if [Date] > Date.From(DateTimeZone.LocalNow()) and [Date] < Date.From(Date.AddMonths(DateTimeZone.LocalNow(),3)) then "Yes" else "No"

Did I answer your question? Mark my post as a solution! and hit thumbs up

Fowmy · ‎05-26-2021

@HenryJS

Add the following as a custom column:

= if [Date] > Date.From(DateTimeZone.LocalNow()) and [Date] < Date.From(Date.AddMonths(DateTimeZone.LocalNow(),3)) then "Yes" else "No"

Did I answer your question? Mark my post as a solution! and hit thumbs up

Power Query Date