cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Microsoft
Microsoft

Contidional nulls query broke in latest update

I have a query that just broke unexpectedly recently after presumably a powerbi update.  You can see the condition that broke in the below image:

= Table.AddColumn(chose2, "NextDate", each if [nd2] is null then null else if [nd2]  >= 2 then [NextDate2] else [NextDate4], type date)

 

It seems that "if [nd2] is null" is causing an error to occur, instead of evaluating properly, when the input is null. This worked successfully previously.

powerbi conditional nulls broke.png

 

1 REPLY 1
Highlighted
Community Support
Community Support

Re: Contidional nulls query broke in latest update

Hi @moody31415 

As tested with the last version, it works as well.

6.png

Could you show a simple example for analysis?

 

 

Best Regards
Maggie

 

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements

August Community Highlights

Check out a full recap of the month!

Experience what’s next for Power BI

Join us for an in-depth look at the new Power BI features and capabilities at the free Microsoft Business Applications Launch Event.

Top Solution Authors