Data Type issue between Excel and Power BI

[Hopeisgood1]

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.

[Anonymous]

Hi @Hopeisgood1 ,

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

[Hopeisgood1 · Accepted solution]

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

[PhilipTreacy]

@Hopeisgood1 

Change the data type in Power BI to Whole Number

Regards

Phil

[Hopeisgood1]

Hi.

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

Thank you!