Power Pivot Data Model Advice

Copper Contributor

Hi, all. I am getting a "relationship may be needed warning" and I'd like to resolve the issue inside my data model. Any advice would be greatly appreciated. I have a feeling that the problem is that my fVolume table is not related to the dAccounts lookup table. 2021-08-04 (1).png2021-08-04 (2).png

1 Reply
Try merging the volume table with the transactions table (Directly or through PQ and instead of using each table directly use the query table in the data model instead