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.
As tested with the last version, it works as well.
Could you show a simple example for analysis?
Community Support Team _ Maggie LiIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Check out a full recap of the month!
Join us for an in-depth look at the new Power BI features and capabilities at the free Microsoft Business Applications Launch Event.