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

Yulyo

Board Regular
Joined
Jul 17, 2017
Messages
86
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.
 

Attachments

  • tst.png
    tst.png
    205.3 KB · Views: 7

Excel Facts

What did Pito Salas invent?
Pito Salas, working for Lotus, popularized what would become to be pivot tables. It was released as Lotus Improv in 1989.

Alex Blakenburg

Well-known Member
Joined
Feb 23, 2021
Messages
630
Office Version
  1. 365
Platform
  1. Windows
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 ?
 

Watch MrExcel Video

Forum statistics

Threads
1,130,402
Messages
5,641,931
Members
417,247
Latest member
Chitaah

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top