Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Cannot convert value " of type Text to type Integer

I'm importing data into Power BI and I have "Duration" column which stores duration in seconds. I want to convert it to minutes so I've created a new column and used the following function: ROUNDUP ...
Need Help
  • v-lili6-msft's avatar
    v-lili6-msft
    7 years ago

    HI, Anonymous 

    That must be mytable[Duration] is a text column, means there must be some text format value in it.

    Please change the data type of this column into number as below:

    Then you filter which row is error.

     

    Best Regards,

    Lin

E0657198's avatar
E0657198
New Member
4 years ago

Hi,

 

I am also facing this issue, Any help is greatly appreciated! 

 

Mileage = IF(CALCULATE(FIRSTNONBLANK('Requested_VIN List'[Mileage],1),FILTER(ALL('Requested_VIN List'),'Requested_VIN List'[VIN]='Fleet Ref_VIN_List'[VIN]))="","-",CALCULATE(FIRSTNONBLANK('Requested_VIN List'[Mileage],1),FILTER(ALL('Requested_VIN List'),'Requested_VIN List'[VIN] ='Fleet Ref_VIN_List'[VIN])))