Forum Discussion

croberts21's avatar
croberts21
Icon for Continued Contributor rankContinued Contributor
3 years ago

PBI will not sum hours correctly

I have PBI Desktop v March 2023. I connect to a Postgresql v9.6.17 database.    I have 2 tables, Jobcost with fields like esthours (which is estimated hours), StartDate and Empid. I have another ...
Need Help
sergej_og's avatar
sergej_og
Icon for Super User rankSuper User
3 years ago

This is often the case when no valid relationship exists between tables (DimTable, FactTable).
Can you post a screen with your datamodel relationships of these two tables?
How is the field JobCost[estcost] defined?