Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
fence0407
Frequent Visitor

How to use Duration.Days with Nulls in Date Field

Using the following function returns nulls where the [Start_Date_c] field has nulls. How do I get it to return 0's instead of nulls?

 

= Table.AddColumn(#"Removed Columns", "Tenure(d)", each Duration.Days(Date.From(DateTime.LocalNow())-Date.From([Start_Date__c])))

 

 

 

 

 

 

1 ACCEPTED SOLUTION
fence0407
Frequent Visitor

I was able to solve the problem by first checking if the Start_Date_c column was null and if so, using Number.FromText to assign a 0 else finish the calculation of Duration.Days().

 

= Table.AddColumn(#"Removed Columns", "Tenure(d)", each if [Start_Date__c]=null then Number.FromText("0") else Duration.Days(Date.From(DateTime.LocalNow())-Date.From([Start_Date__c])))

View solution in original post

1 REPLY 1
fence0407
Frequent Visitor

I was able to solve the problem by first checking if the Start_Date_c column was null and if so, using Number.FromText to assign a 0 else finish the calculation of Duration.Days().

 

= Table.AddColumn(#"Removed Columns", "Tenure(d)", each if [Start_Date__c]=null then Number.FromText("0") else Duration.Days(Date.From(DateTime.LocalNow())-Date.From([Start_Date__c])))

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

Top Solution Authors
Top Kudoed Authors