Question about data modeling

[PBI_37]

Hi everyone,

I have a question about my model.

I have 2 fact tables (actual and forecast) and 2 dimension tables (Products and Calendar).

I want to calculate the difference between the actual and the forecast at the BatchNum level.

It works at the Products level but not with the BatchNum.

Is it necessary to create a BatchNum dimension table?

Expected results :

Here is the link of the PBI file :

https://drive.google.com/file/d/1UwguKZWwl4dKBQMoDQBBPdxnS3rHLh9M/view?usp=share_link

Thank you for your help

[vojtechsima · Accepted solution]

Hello, @PBI_37 ,
Yes, you're right. You can append both fact tables, keep only BatchNum column, remove duplicity and make that as third dimension and connect it back to the fact tables as normal dimension.

[PBI_37 · Accepted solution]

Thank you vojtechsima

[vojtechsima · Accepted solution]

Hello, @PBI_37 ,
Yes, you're right. You can append both fact tables, keep only BatchNum column, remove duplicity and make that as third dimension and connect it back to the fact tables as normal dimension.