Forum Discussion

Sibi_Joseph's avatar
Sibi_Joseph
Copper Contributor
Jul 13, 2022
Solved

change the data type True or False to 1 or 0 using power query

Can somebody please help me to change the data type True or False to 1 or 0 using power query 
excel
power bi
  • Riny_van_Eekelen's avatar
    Riny_van_Eekelen
    Jul 13, 2022

    Sibi_Joseph Change the data type to "whole number". That should transform it to ones and zeroes.

Riny_van_Eekelen's avatar
Riny_van_Eekelen
Platinum Contributor
Jul 13, 2022

Sibi_Joseph Change the data type to "whole number". That should transform it to ones and zeroes.

Resources