Share feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.
Sign up nowGet Fabric certified for FREE! Don't miss your chance! Learn more
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?
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
Check out the January 2026 Power BI update to learn about new features.
| User | Count |
|---|---|
| 5 | |
| 4 | |
| 4 | |
| 3 | |
| 2 |
| User | Count |
|---|---|
| 15 | |
| 9 | |
| 9 | |
| 7 | |
| 5 |