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.
Hello all,
Please find the sample. Thank you.
https://drive.google.com/file/d/1OAq0HrmsC3KPq-_LiK-nbV_eeVeWJJOA/view?usp=sharing
Hi @Anonymous ,
I am not sure if it is achievable in Power BI - perhaps a combo of Power Query and DAX is needed. But that aisde, where is volume produced in your data?
Proud to be a Super User!
Hi @danextian ,
Receipt Qty in Alt.UoM is "volume produced".
I am using "Smash_Fact" Table. This table is the combination of "Albatross" and "ZPOCL".
Hi @Anonymous ,
Please also post your data source. My initital assessment requires modifying the table in PQ.
Proud to be a Super User!
Hi @danextian
Shared a zip with the sample files. Also, a file named "output of model" is attached, to explain how the output is requested.
https://drive.google.com/file/d/10I9KUu-eRME7Vm0MmdifOueaU7ZK_1aK/view?usp=sharing
Hi @Anonymous ,
Please post a sample data that can be copy-pasted as text.
Proud to be a Super User!
User | Count |
---|---|
88 | |
72 | |
69 | |
65 | |
57 |
User | Count |
---|---|
95 | |
93 | |
91 | |
75 | |
69 |