- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
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
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
Senior BI Consultant
Information Workers
http://www.iwco.co
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Can you share your "M" code?
Regards
Senior BI Consultant
Information Workers
http://www.iwco.co
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
Senior BI Consultant
Information Workers
http://www.iwco.co

Helpful resources
Subject | Author | Posted | |
---|---|---|---|
01-30-2025 10:04 PM | |||
09-05-2023 03:12 AM | |||
08-21-2018 06:05 AM | |||
01-15-2018 09:15 AM | |||
07-24-2024 03:49 AM |
User | Count |
---|---|
141 | |
115 | |
84 | |
63 | |
48 |