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,
Thanks for taking the time to read my post. I am new to DAX and have been trying to use sums/filters/ifs to identify jobs that procurement need to focus on. I have added a snip of some example data (The real data has hundreds of jobs) and an example of what I am trying to do. The first table is an example of the data, I am then trying to filter to each job, sum the required column, and then sum the quantity column (But sum only to the max of the required column). Then I would add a readiness column (Quantity Sum/Required Sum) as a percentage and sort by lowest. If you could please have a look and let me know how to do this, or where I can look to get some help I would greatly appreciate it.
Hi,
I created an example document on how you can achieve this.
https://1drv.ms/u/s!AnIEh6WhI4Jog5Vz1k9Ap5T1xyjDag?e=ZL0jZj
Essentially, I added a column =
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 |
---|---|
41 | |
21 | |
21 | |
14 | |
13 |
User | Count |
---|---|
43 | |
36 | |
33 | |
18 | |
18 |