Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.
I am working with a Conditional Column and I want to make the Date Current Date +28 Days instead of hard coded below
= Table.AddColumn(#"Filtered Rows", "Custom Order Finish Date", each if [Ordfinish] >= #date(2022, 7, 28) then "TBD" else [Ordfinish])
Solved! Go to Solution.
Replace #date(2022, 7, 28) with
Date.AddDays(Date.From(DateTime.FixedLocalNow()),28)
DateTime.LocalNow()
and
Date.AddDays()
are the 2 functions you need
Add 28 days to:
Date.From(DateTime.LocalNow())
- https://docs.microsoft.com/en-us/powerquery-m/date-adddays
- https://docs.microsoft.com/en-us/powerquery-m/datetime-localnow
Replace #date(2022, 7, 28) with
Date.AddDays(Date.From(DateTime.FixedLocalNow()),28)
Thanks this worked
Check out the November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.