Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
I am looking to add a new column with a bit of equations in it.
This is what I am hoping to achieve in language:
IF Job Requistion Status = "Closed" then use the EndOfMonth of the End date
IF Job Requisition Status = "Filled" and End Date is null then EndOfMonth of the Requisition Close Date
Else EndofMonth on todays date.
Any help appreciated.
Solved! Go to Solution.
Use this
= if [Job Requistion Status]="Closed" then Date.EndOfMonth([End Date]) else
if [Job Requistion Status]="Filled" and [End Date]=null then Date.EndOfMonth([Requisition Close Date]) else Date.EndOfMonth(Date.From(DateTime.FixedLocalNow()))
Use this
= if [Job Requistion Status]="Closed" then Date.EndOfMonth([End Date]) else
if [Job Requistion Status]="Filled" and [End Date]=null then Date.EndOfMonth([Requisition Close Date]) else Date.EndOfMonth(Date.From(DateTime.FixedLocalNow()))
Thank you!
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.