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.
Hi Dears,
I have the following case and looking for your expertise. Suppose I have the following table I need to compare how much days resources has booked against the forecast
Period Name Number of hours
Aug X 8
Aug X 8
Aug X 8
Aug Y 7
Aug Y 5
Sept
. .
So X booked 3 days, and Y booked 1.6 days.
Now my forecast is as follow
Aug X 5days
Aug Y 4 days
Sept X 3 days
. .
How can I represent that graphically? I am looking to show each resource how much he booked against the forecast. As well as to show the total number of days because by all resources against the total forecast. Many thanks in advance
hi,@abukapsoun
After my research, you can do these as below:
Step1:
use this formula to create a table as below:
Table = FILTER(GENERATE(SUMMARIZE(Table1,Table1[Period],Table1[Name],"total days",CALCULATE(SUM(Table1[Number of hours]))/8),Table2),Table1[Period]=Table2[Period1]&&Table1[Name]=Table2[Name1])
Step2;
drag the fields into table
Here is pbix, please try it.
https://www.dropbox.com/s/srap6ny87r45mla/compare%20values.pbix?dl=0
Regards,
Lin
Thank you very much @v-lili6-msft that looks exactly what I am looking for.
Now I will try to mirror your proposal on my file.. I hope it works 🙂
hi, @abukapsoun
Could you please tell me if your problem has been solved? If it is, could you please mark the helpful replies as Answered?
Best Regards,
Lin
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 |
---|---|
107 | |
100 | |
80 | |
63 | |
58 |
User | Count |
---|---|
148 | |
111 | |
94 | |
84 | |
67 |