Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago
Solved

Data Type issue between Excel and Power BI

Hi    In excel - for the Incident ID, the data type is General In Power BI, it's text.   I do not see a General data type in Power BI and the calculation I have such as SUM and it cannot use it ...
Need Help
Tutorial Requests
  • Anonymous's avatar
    Anonymous
    1 year ago

    Hi - I figured it out. I duplicated the column from Incident ID and did a split delimiter function to get rid of the INC. Then I renamed the duplicated column to INC Value and changed the datatype to whole number. I also updated the DAX code. That fixed the problem.

     

     

     

    NOW I am trying to figure out the sort of Priority - UGH!!

     

     

     

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi Anonymous ,

You have characters in this column of data and Power BI is unable to recognize the column as a numeric type

Also this DAX of yours is a bit confusing, what exactly are you trying to calculate? Would you mind providing the sample data from your INC table and Age Groups table?


Best Regards,
Dino Tao

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi - I figured it out. I duplicated the column from Incident ID and did a split delimiter function to get rid of the INC. Then I renamed the duplicated column to INC Value and changed the datatype to whole number. I also updated the DAX code. That fixed the problem.

 

 

 

NOW I am trying to figure out the sort of Priority - UGH!!