Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code FABINSIDER for a $400 discount.
Register nowGet inspired! Check out the entries from the Power BI DataViz World Championships preliminary rounds and give kudos to your favorites. View the vizzies.
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?
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code FABINSIDER for a $400 discount!
Check out the February 2025 Power BI update to learn about new features.
User | Count |
---|---|
21 | |
15 | |
11 | |
10 | |
10 |