Supplies are limited. Contact info@espc.tech right away to save your spot before the conference sells out.
Get your discountScore big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount
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?
User | Count |
---|---|
13 | |
8 | |
8 | |
7 | |
5 |
User | Count |
---|---|
21 | |
15 | |
15 | |
10 | |
7 |