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 as a string. If I use COUNT, it is all the same 😕

 

The dashboard is not doing this right at all.

 

 

 

 

 

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!!

     

     

     

4 Replies

  • PhilipTreacy's avatar
    PhilipTreacy
    Super User
    1 year ago

    Anonymous 

     

    Change the data type in Power BI to Whole Number

     

     

    Regards

     

    Phil

    • Anonymous's avatar
      Anonymous
      Not applicable
      1 year ago

      Hi.

       

      I replied back in the first reply. I fixed the issue - please see my response 🙂

       

      Thank you!

  • 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!!