Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredGet Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
Hi,
I am currently trying to calculated weeks of supply in a Power BI matrix. This goes well for the lowest level (green, 201/7), but not for the aggregate level (red, 35828/2461).
Which function should I use to do this?
I am currently using the below function.
hi @schans11
why not using the [weeks supply] measure in the last column of your second screeshot ?
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
Check out the October 2025 Power BI update to learn about new features.
| User | Count |
|---|---|
| 8 | |
| 6 | |
| 6 | |
| 5 | |
| 4 |
| User | Count |
|---|---|
| 25 | |
| 15 | |
| 8 | |
| 8 | |
| 8 |