DataFormat.error We couldnt convert to Number...

[Pammy2411]

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.

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.

Thanks in advance,

Pamela

[jbocachica]

Can you share your "M" code?

Regards

[Pammy2411]

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

[jbocachica · 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