topic divide a value over the next day/months using a day% in DAX Commands and Tips

divide a value over the next day/months using a day%

quido — Wed, 20 Dec 2023 09:50:13 GMT

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....

Re: divide a value over the next day/months using a day%

Greg_Deckler — Wed, 20 Dec 2023 11:37:16 GMT

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?

Re: divide a value over the next day/months using a day%

quido — Wed, 20 Dec 2023 13:00:12 GMT

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