Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
hb0135
Helper III
Helper III

Data Format Error

Hello,

I Have change the data in  both type i.e Whole number and Text also then also i am getting an error and the data is 13-2,13-3 format 

 

Thanks

hb0135_0-1679992289930.png

hb0135_1-1679992302622.png

 

1 ACCEPTED SOLUTION

You can't convert a dash to number.

View solution in original post

5 REPLIES 5
hb0135
Helper III
Helper III

Hello,

I am not trying to Subtract it is dash 13-3

You can't convert a dash to number.

Hello, 

But i am also trying  to convert that 13-3 into text then also ts showing and error

Hi,

Ok Thanks 

 

JorgePinho
Solution Sage
Solution Sage

You're trying to convert "13-3" to number but that is text. Power BI can't make the subtraction and assume it is a number (10).

Helpful resources

Announcements
Sept PBI Carousel

Power BI Monthly Update - September 2024

Check out the September 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

Sept NL Carousel

Fabric Community Update - September 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors