HenryJSPost Prodigy5 years agoSolvedPower Query Date 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 Show MoreFowmy5 years agoHenryJS 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"
Fowmy5 years agoHenryJS 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"
Fowmy5 years agoHenryJS 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"
FowmySuper User5 years agoHenryJS 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"
Related contentPower Query datesFind Most Recent Date Relative to another Date Column in Power QueryDate Conversion Error Power BI/QueryData transform using power queryMax date in power query
