Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Please help! How can I use DAX to solve a simple excel task!
I know the values in column A and the first Sum 1000 and need to calculate the Sum for each value in column A
B C
1 % Sum
2 2,0% 1000
3 3,5% 965
4 3,0% 936,05
C3=C2-B2*C2
C4=C3-B3*C3 etc.
Thanks!
Calculated column
@agolumeste , assume you have sequence in column A that can be used then try like
sumx(filter(Table, [A] =earlier([A]) -1),earlier([C]) - (earlier([C]) *earlier([B])))
or
sumx(filter(Table, [A] =earlier([A]) -1),([C]) - (([C]) *([B])))
or add an index column like
https://stackoverflow.com/questions/45715963/creating-an-index-column-for-power-bi
Thanks for help!
I can't use the EARLIER function because I calculate a column that doesn't exist yet.
User | Count |
---|---|
22 | |
11 | |
8 | |
6 | |
6 |
User | Count |
---|---|
26 | |
13 | |
11 | |
9 | |
6 |