Is there a way within conditional column to set "todays" date so it's dynamic, so today it would show 1/29, ttomorrow 1/30, etc. Otherwise is there a way to do this same within power Query?
1 ACCEPTED SOLUTION
Hi @jcastr02,
You need to add a date so that is filter and then edit the syntax on the formula bar:
= Table.AddColumn(#"Changed Type", "Custom", each if [Date] <= Date.From (DateTime.FixedLocalNow()) then "Active" else if [Date] >= Date.From (DateTime.FixedLocalNow()) then "Future" else null)
Regards
Miguel Félix
Did I answer your question? Mark my post as a solution!
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsHi @jcastr02,
You need to add a date so that is filter and then edit the syntax on the formula bar:
= Table.AddColumn(#"Changed Type", "Custom", each if [Date] <= Date.From (DateTime.FixedLocalNow()) then "Active" else if [Date] >= Date.From (DateTime.FixedLocalNow()) then "Future" else null)
Regards
Miguel Félix
Did I answer your question? Mark my post as a solution!
Proud to be a Super User!
Check out my blog: Power BI em Português
Helpful resources
Fabric Community Update - July 2025
Find out what's new and trending in the Fabric community.
Power BI Monthly Update - July 2025
Check out the July 2025 Power BI update to learn about new features.
