Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
Hi all, looking for a dax solution on how to simple divide a value over the next day/months using a day%
like this: value to divide is 100
| perc | day | result |
| 10% | 1-1-2024 | =10 |
| 10% | 1-2-2024 | =10 |
| 15% | 1-3-2024 | =15 |
| etc.... |
Hi Greg, it should indeed be a measure. I have a tabel with dates(days) and a unique percentage, and a table with yearly volumes like the 100. Goal is to distribute the 100 thru the percentages over the year
@quido Not sure what you mean by this 10% / 100 = .001. Do you want to have 10% * 100 = 10? Confused. Also, is this a column or a measure? Is [perc] really .1 formatted as a percentage?
Check out the November 2025 Power BI update to learn about new features.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
| User | Count |
|---|---|
| 9 | |
| 9 | |
| 8 | |
| 6 | |
| 5 |
| User | Count |
|---|---|
| 23 | |
| 16 | |
| 15 | |
| 14 | |
| 8 |