Power Query and Data Model Power Pivot

[dicken]

Hi,
I've had a problem where I'd loaded a table into power query, added to the data model and opened in power pivot but
when I tried for example to calculate a total so SUMX(Table1, Table[Units] ) , I got an error,
If I loaded the same Source excel table into power pivot directly, I could do the operation, I haven't been able to replicate the problem,
does anyone have any suggestions as to causes?

Richard.

 

[SpillerBD]

Verify the Data Type in PowerQuery. Remove any errors.

 

[dicken]

Verify the Data Type in PowerQuery. Remove any errors.

Yes, I think that was the problem, I'll sign this off thanks for the response.

Richard.