Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.
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.
Check out the November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.
Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!