Wrong results when "add to Data Model" is enabled.

[Yulyo]

Hello all,

I am a total newbie with power query, but i just wanted to to some "simple" things:
- new query / from file
- deleted some columns, add a sum column, replace null with zero, change type as whole number
- close and load to: table + existing worksheet + add this data to the data model

After the query is executed i have the following results (See attached image):
- power query = data is correct
- resulted table and power pivot = wrong data

If i don't add the data to data model, everything is fine...
Am i doing something wrong? The entire scope is to be able to have a final column with stock (yesterday stock + today's production - today's export).

Thank you in advance.

 

[Alex Blakenburg]

Did you ever sort this out ?
Issues with data model typically have something to do with the relationships. Have you checked the Diagram view for incorrect connections or missing connection ?