Forum Discussion

MKPartner's avatar
MKPartner
Icon for Helper II rankHelper II
11 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
    11 months ago

    Hello, 

     

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

KarinSzilagyi's avatar
KarinSzilagyi
Icon for Super User rankSuper User
11 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: