Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Folks,
I have an excel that contains 2 cells. The first contains a total value $ and the second is a list of who that value is assigned to. In some cases, the assigned is a single dept, in others it can be assigned to multiple depts. In those cases, they list the depts in that single cell separted by a /.
I want to be able to assign an equal portion of the total value against each of the assigned depts and report it within my PowerBI report. What is the best way to approach this?
Solved! Go to Solution.
Here you go. You need to modify the data in the M code. Here I am attaching a sample file for your reference.
https://1drv.ms/u/s!AilGKsSdStq8kTzm2cP2xPlfRdPd?e=wUdHEz
If your issue resovles. Please accept my reply as Solution.
If your issue resovles. Please accept my reply as Solution.
Fantastic. Thank you.
Here you go. You need to modify the data in the M code. Here I am attaching a sample file for your reference.
https://1drv.ms/u/s!AilGKsSdStq8kTzm2cP2xPlfRdPd?e=wUdHEz
Some data and the results you are looking for. So, it will be easy to get answered.
The data I see looks like:
I want to report it as:
Basically, for each line item, the value will be aportioned based on the number of the assigned depts.
User | Count |
---|---|
84 | |
80 | |
72 | |
71 | |
55 |
User | Count |
---|---|
108 | |
106 | |
93 | |
85 | |
67 |