Forum

Notifications
Clear all

Unique Values Question for How to Build Power BI Reports from Start to Finish

3 Posts
2 Users
0 Reactions
69 Views
(@mathewfok)
Posts: 2
New Member
Topic starter
 

Hi, I was just going through the data for some reason to make sure all the fact data was lined up comparing apples to apples from one another. By doing this, I used all of the Budget data and Forecast data and then just the January Actual data as that probably covered the basis. I removed all the duplicates for IT Department, Cost Element and Country. The excel workbook that I provide the missing data in each scenario. Can you please explain why some data is in some fact data like Forecast for IT Dept, but missing in others as well as for the other situations? What is it suppose to be like in this tutorial versus how it should or could be in real life? Thanks!

 
Posted : 16/04/2023 8:59 pm
(@mynda)
Posts: 4761
Member Admin
 

Hi Matthew,

I didn't create the dataset, but it's quite common in the real world to budget for something that doesn't happen, or have new expenses that you didn't plan etc., so I wouldn't read too much into it.

Mynda

 
Posted : 17/04/2023 3:57 am
(@mathewfok)
Posts: 2
New Member
Topic starter
 

Thank you Mynda, that is exactly what I was thinking 🙂

 
Posted : 17/04/2023 10:58 am
Share: