Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi all,
I'm trying to figure out how to solve the following challenge.
I have these two tables with data
What I want to achieve is the following:
Short explanation: I need my formula to check if the SUM of duration from Table1 is 60 (in this case) and if not, complement it with P4 and duration needed to achive the SUM of 60.
Please note that P4 can appear in Table 1 and that I need this output in table or matrix that can be sorted by Resources.
Thanks all for help!
Solved! Go to Solution.
Here you go
Proud to be a Super User!
Hi, @dsj8wksnnckk
I have reproduced your problem and was able to solve it.
Need to transform. I am adding the pbix file.
Result:
Proud to be a Super User!
Hey,
thanks for the assistance.
I'm not quite sure this solution would be applicable. I see one of your steps is transpose table, but my table will have unlimited number of rows (thats what the 3 dots mean on the bottom).
What do you think?
Hey, If you check it again, those were the automated steps that PQ performed. I took a sheet not a table when importing data to PBI PQ. So those were the unnecessary steps.
See below image:
these steps are the main ones. I did not use transpose. I loaded the tables and the result is same.
Proud to be a Super User!
Hey, can you re-upload the file? It was deleted and I seem to have lost it 😞
sure. I will upload it once I get home
Proud to be a Super User!
User | Count |
---|---|
95 | |
86 | |
78 | |
72 | |
67 |
User | Count |
---|---|
111 | |
104 | |
84 | |
65 | |
63 |