Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hello Community, This is my first post. So please guide me to the right post if it is repeated by any chance.
Please see the screenshot above. My objective is not to have those repeated values.
Is it possible to achieve that? If so, can you please guide me in the right direction?
If possible, can you please explain to me why we are getting these repeated values?
Solved! Go to Solution.
It looks like a granularity mismatch. Here's a highly relevant article on the topic:
https://www.sqlbi.com/articles/budget-and-other-data-at-different-granularities-in-powerpivot/
(Pay particular attention to the IsBudgetValid measure.)
It looks like a granularity mismatch. Here's a highly relevant article on the topic:
https://www.sqlbi.com/articles/budget-and-other-data-at-different-granularities-in-powerpivot/
(Pay particular attention to the IsBudgetValid measure.)
Thank you very much Alexis.
Huge help mate.
If you don't mind further my query then I will like to ask you the following question:
As a practitioner of Project management, I have to do regular forecasts of various resources. I have thought about doing it in Excel and bringing it into Power BI for reporting purposes. But it will be great if I can do it within Power BI. If you or any community member have a good resource for me to refer to then please share it with me. It will be highly helpful.
The DAX Patterns linked in that article discuss forecasts:
https://www.daxpatterns.com/budget/
Beyond that, I don't have specific recommendations and I'm sure your web searching would be at least as good as mine given your knowledge of your own situation.
User | Count |
---|---|
84 | |
80 | |
72 | |
71 | |
55 |
User | Count |
---|---|
108 | |
106 | |
93 | |
85 | |
67 |