Forum Discussion
compare values
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
3 Replies
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
