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.
Join our Fabric User Panel
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
