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
Solved! Go to 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.
Thank you vojtechsima
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.