Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers. Get Fabric certified for FREE! 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?
Check out the April 2025 Power BI update to learn about new features.
Explore and share Fabric Notebooks to boost Power BI insights in the new community notebooks gallery.
User | Count |
---|---|
19 | |
11 | |
10 | |
9 | |
8 |
User | Count |
---|---|
20 | |
13 | |
8 | |
7 | |
6 |