question

TeronFunasaki-5743 avatar image
0 Votes"
TeronFunasaki-5743 asked DSPatrick answered

Group By Data Format Error in Power Query

Hi,

I'm attempting to compare two tables of similar structure with data from different days. When I try to Group By with the below parameters Power Query returns "DataFormat.Error: We couldn't convert to Number. Details: 100-0009000696". I'd like to group by the text formatted "LINE ID" column and return two columns containing the sum of the differences for the Open Units and Open Gross columns, which are both formatted as decimal numbers (i already confirmed the formats match between both tables). I'd be extremely grateful for any assistance in setting up the correct Group By parameters.

191037-image.png

191087-image.png


191096-image.png


power-query-not-supported
image.png (31.3 KiB)
image.png (90.8 KiB)
image.png (5.2 KiB)
5 |1600 characters needed characters left characters exceeded
Toggle Comment visibility. Current Visibility: Visible to all users

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

DSPatrick avatar image
0 Votes"
DSPatrick answered

Power query is not currently supported here on Q&A. The product group for Power Query actively monitors questions over at
https://community.powerbi.com/t5/Power-Query/bd-p/power-bi-services


--please don't forget to Accept as answer if the reply is helpful--


5 |1600 characters needed characters left characters exceeded
Toggle Comment visibility. Current Visibility: Visible to all users

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.