Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
106 | |
98 | |
75 | |
63 | |
62 |
User | Count |
---|---|
135 | |
105 | |
104 | |
80 | |
65 |