Forum Discussion
Problem with data type from an excel file
Hello,
I have a simple excel file with a single table that I'm trying to implement to my report. My problem is that one of the colums has number data that power bi recognises as dates.
The columns has data like 2/4, 3/4 etc. Basically it says how many tests have been done (2 out of 4, 3 out of 4 etc.).
When I import the excel to Power BI that columns shows dates, when I change the type in Power BI to number I get weird numbers like "42462" or something. How can I fix that?
4 Replies
Look at my response here...
http://community.powerbi.com/t5/Desktop/Sort-a-columns-by-the-rows/m-p/29830#U29830
Basically don't load the Excel data immediately - hit EDIT first - then in the Query Editor change the Data Type to decimal
then go ahead and load to the Data Model
let me know if this works.
