Forum Discussion

abukapsoun's avatar
abukapsoun
Post Patron
7 years ago

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 ...
Need Help
Show and Tell
v-lili6-msft's avatar
v-lili6-msft
Community Support
7 years ago

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's avatar
abukapsoun
Post Patron
7 years ago

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's avatar
    v-lili6-msft
    Community Support
    7 years ago

    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