Forum Discussion

mork's avatar
mork
Icon for Helper V rankHelper V
10 years ago
Solved

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 colum...
Need Help
  • Sean's avatar
    Sean
    10 years ago

    mork Go back in Excel and format the column as Fraction - it should then automatically recognize it as numbers

     

Sean's avatar
Sean
Icon for Community Champion rankCommunity Champion
10 years ago

mork Go back in Excel and format the column as Fraction - it should then automatically recognize it as numbers

 

mork's avatar
mork
Icon for Helper V rankHelper V
10 years ago

Thanks a lot!!