Forum Discussion

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

raisurrahman's avatar
raisurrahman
Icon for Helper II rankHelper II
10 months ago

MKPartner 

I’m fairly certain there are nulls. As @KarinSzilagyi suggested, please check Column quality and Column profile. By default, Power Query infers data types from only the first 1,000 rows. If possible, load the data into an Excel table and review the entire dataset.

Regards,
Rais