Reply
Pammy2411
Frequent Visitor

DataFormat.error We couldnt convert to Number...

Hi,

 

I am having issues with applying my query after i unpivot columns in my data model. When i first input my data, there are columns with values for every week. Power BI identifies the columns as values automatically.

 

Capture.PNG

However, once i unpivot the columns W1, W2, W3, W4, and W5 it gives me the following error: DataFormat.error We couldnt convert to Number...

Not too sure why it is giving me that error, since the values are all Numbers and it automatically makes a "Value" Column for me with the data format as Decimal Number.

 

Capture.PNG

 

Thanks in advance,

Pamela

1 ACCEPTED SOLUTION

That is beacuse when you made the pivot, it's necessary to create an aggregation and in that moment is when you realize your data issues, before that your data is just rows, for example, if you instead of create a pivot, create a meassure, you will see the same error.

 

Regards

John Bocachica
Senior BI Consultant
Information Workers
http://www.iwco.co

View solution in original post

3 REPLIES 3
jbocachica
Resolver II
Resolver II

Can you share your "M" code?

 

Regards

John Bocachica
Senior BI Consultant
Information Workers
http://www.iwco.co

Hi @jbocachica,

 

I ended up finding some #N/A in my data, which was what was causing this problem.

 

However, this made me question something else: How come this problem only appeared whenever i unpivoted the columns? Whenever they were pivoted, i did not receive this error and could use the data perfectly.

 

Thanks,

Pamela

That is beacuse when you made the pivot, it's necessary to create an aggregation and in that moment is when you realize your data issues, before that your data is just rows, for example, if you instead of create a pivot, create a meassure, you will see the same error.

 

Regards

John Bocachica
Senior BI Consultant
Information Workers
http://www.iwco.co
avatar user

Helpful resources

Announcements
March PBI video - carousel

Power BI Monthly Update - March 2025

Check out the March 2025 Power BI update to learn about new features.

March2025 Carousel

Fabric Community Update - March 2025

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

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)