Forum Discussion

PBI_37's avatar
PBI_37
Helper I
3 years ago
Solved

Question about data modeling

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

 

 

 

 

Need Help
  • vojtechsima's avatar
    vojtechsima
    3 years ago

    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.

2 Replies

  • vojtechsima's avatar
    vojtechsima
    Super User
    3 years ago

    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.