Share via

Group By Data Format Error in Power Query

Teron Funasaki 1 Reputation point
2022-04-07T21:26:35.01+00:00

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

Not Monitored
Not Monitored
Tag not monitored by Microsoft.
37,795 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2022-04-07T21:32:35.547+00:00

    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--

    0 comments