Forum Discussion
Solved
Tabular Model gives different results than SQL Query
I am having trouble with some records and how they are aggregating inside our Tabular Model compared to our Data Warehouse. I have a custom query built that pulls a record number, the order of the r...
This issue is resolved now. I have partitions on some tables in our Model and the date I was partitioning on was the wrong date, so the records were being counted in both partitions instead of having the entire record sitting in only 1 partition.
Hi jbirrer ,
Could you please share the formula you are using to generate "OfferTransportCount" if it does not contain any confidential information? Is there any record in your datatable that OfferOrder=4? Please don't have any Confidential Information or Real data in your reply.
Best regards,