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
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

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

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.