compare values

[abukapsoun]

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

[v-lili6-msft]

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

[abukapsoun]

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 🙂 

[v-lili6-msft]

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