Forum Discussion

Pammy2411's avatar
Pammy2411
Frequent Visitor
10 years ago
Solved

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 a...
Need Help
  • jbocachica's avatar
    jbocachica
    10 years ago

    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

jbocachica's avatar
jbocachica
Resolver II
10 years ago

Can you share your "M" code?

 

Regards

Pammy2411's avatar
Pammy2411
Frequent Visitor
10 years ago

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