topic Question about data modeling in Desktop

Question about data modeling

PBI_37 — Sun, 02 Apr 2023 16:50:08 GMT

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

Re: Question about data modeling

vojtechsima — Sun, 02 Apr 2023 18:57:53 GMT

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.

Re: Question about data modeling

PBI_37 — Mon, 03 Apr 2023 18:19:23 GMT

Thank you vojtechsima