Forum Discussion
impact % h on company, Ranking
Hi Sand36,
Thank you for reaching out to the Microsoft fabric community forum. Also, thanks to ThomasWeppler, for his inputs on this thread. I reproduced the scenario, and it worked on my end. I used it as sample data and successfully implemented it.
outcome:
I am also including .pbix file for your better understanding, please have a look into it.Hope this clears it up. Let us know if you have any doubts regarding this. We will be happy to help.
Thank you for using the Microsoft Fabric Community Forum.
Thanks
No, I want to know what impact the percentage share of hours on a job has on the reduction of total hours on the assignment. In other words, which company completes the job fastest, taking into account that several companies can work on one assignment, always in a different configuration of hours.
So you want a list of all the time a job has each job has been done.
Make a slicer that let you pick a job. (just put the job id into a slicer.)
Make a table where you have the id for each time the job has been completed, maybe and index if you do't have a uniq id, but an uniq id id better.
add the hours to the table.
Hours = selectedvalue(order[hours])
Write in Dax a code that look at the average time spend on the task.
Average = divide(selectedvalue(order[hours], sum(order[hours],0)
Write a new dax that looks at the diffrence.
Saved time = [Average] - [Hours]
I am not sure about all the name of the table since I don't have much info, but this might get you started. 🙂
RBH Zlecenie Nazwa_APT_FZ 4 KW A 5 KD B 6 KX C 7 KW A 3 KD A 2 KX C 4 KW C 6 KD A 3 KX D 4 KW D
This is my Tabel 🙂 i wloud like to know wich company is Making my Zlecenie fastest.
Because some company work slow and id i put them on Zlecenie they need much more hours to end Zlecenie.
In tabel i have only Ended Zlecenie.Suma z RBH Etykiety kolumn Etykiety wierszy A B C D Suma końcowa KD 20,45% 11,36% 0,00% 0,00% 31,82% KW 25,00% 0,00% 9,09% 9,09% 43,18% KX 0,00% 0,00% 18,18% 6,82% 25,00% Suma końcowa 45,45% 11,36% 27,27% 15,91% 100,00%