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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
ingbra
New Member

Compare dates to return a value (KPI)

I' new at this, and I want to compare the estimated delivery dates to the actual delivery dates and return a value that can be used to measure to a %KPI. I get an error message for the records that are null.

Expression.Error: We cannot convert the value null to type Logical.
Details:
    Value=
    Type=Type

Can I only use TRUE or FALSE as output?

1 ACCEPTED SOLUTION
MarcelBeug
Community Champion
Community Champion

You can have null as output for logicals.

 

However, if you want to test on that logical, you get the error you mention.

 

Null in logical.png

Specializing in Power Query Formula Language (M)

View solution in original post

1 REPLY 1
MarcelBeug
Community Champion
Community Champion

You can have null as output for logicals.

 

However, if you want to test on that logical, you get the error you mention.

 

Null in logical.png

Specializing in Power Query Formula Language (M)

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.