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.
Hello all
I hope you can help me. 🙏
I have a case where I need to compare used time from a fact-table (invoice) with a static estimated time that is located in another table (KIT-tabel).
The estimated time have a dimension called KIT no., which also relates to some of the rows within the fact-tabel, but the used time doesn't have a KIT-dimension (it is blank).
The used time also needs to be recalculated based on the time efficiency of the role of the user.
How can I distribute the recalculated used time on the KIT no. rows based on the KIT no.'s share of the invoices estimated time?
Here are the tables and the last picture is the outcome I hope for:
Can anyone help me on which way to go to solve this?
I have attached a PBIX-file as well, which can be found here: https://we.tl/t-7gPh0uJH5f
Thank you in advance! 😃
Hello @Anonymous
Unable to download the file. Seems like the link/transfer is expired. Could you please share again?
Thank You.
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 |
---|---|
47 | |
26 | |
19 | |
14 | |
10 |
User | Count |
---|---|
58 | |
50 | |
44 | |
19 | |
18 |