Forum Discussion

MKPartner's avatar
MKPartner
Helper II
10 months ago
Solved

[Expression.Error] cannot convert null value to Logical

Hi Guys,    I have two columns where both are without "null" values:  PV_orig = ([orig_tot_fabric_assgn_qty]*[prod_cost])/4.84) and (([g1_metres]+[g0_metres]+[g2_metres]+[dk_metres]+[allow_me...
Need Help
  • MKPartner's avatar
    MKPartner
    10 months ago

    Hello, 

     

    I solved the issue with DAX function. It didn't work for me in Power Query. 

KarinSzilagyi's avatar
KarinSzilagyi
Super User
10 months ago

Hi MKPartner just to be 100% sure: Did you check e.g. via "View > Column profile" or "View > Column Quality" in Power Query Editor that there definitely aren't any null-values in any of the columns used in a mulitplication for your added columns?


Don't forget to switch to "Column profiling based on entire data set" if your table has >1000 rows: