Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi All ,
I need some inputs regarding adding a new field "Status" . I have start date and End Date .
The logic Is , if current date is between startdate and End date then the status is "Active" else "Inactive"
Im using this
= Table.AddColumn(tablename, "Status", each if [Start_Date] <= Date.From(DateTime.LocalNow()) then "Active" else if [End_Date] >= Date.From(DateTime.LocalNow()) then "Active" else "Inactive")
TIA!
Solved! Go to Solution.
Sorry, I have updated the script to use your table name.
Table.AddColumn(tablename, "Status", each let today = Date.From ( DateTime.FixedLocalNow() ) in if [Start_Date] <= today and [End_Date] >= today then "Active" else "Inactive", type text)
Sorry, I have updated the script to use your table name.
Table.AddColumn(tablename, "Status", each let today = Date.From ( DateTime.FixedLocalNow() ) in if [Start_Date] <= today and [End_Date] >= today then "Active" else "Inactive", type text)
Hello! Here you go:
Table.AddColumn(#"Changed Type", "Status", each let today = Date.From ( DateTime.FixedLocalNow() ) in if [StartDate] <= today and [EndDate] >= today then "Active" else "Inactive", type text)
@jennratten Thanks for replying . Im getting this
"The name 'Changed Type' wasn't recognized. Make sure it's spelled correctly."
Im new to powerQuery . Any idea what im missing ?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.