Forum Discussion
Change column type to int64 when it includes missing data
I have a column of numbers, but it also includes some "Missing data" values. Currently the column is of type 'text', but I need the column the be of type 'int64', however Power BI freaks out that "Mi...
Figured it out. Just replaced all "Missing data" strings with nothing, which PBI defaults to "null" values (NaN). Then the column can be cast to int64.
Figured it out. Just replaced all "Missing data" strings with nothing, which PBI defaults to "null" values (NaN). Then the column can be cast to int64.