Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi everyone,
I need some help and I gonna try to explain. I need to create a measure or a calculated column wich calculates de SUM of the row and the previous rows. There is also a condition that when we reach a new year (column Year) the measure must "restart".
I hope someone can help me, thanx everyone!
Solved! Go to Solution.
Hi Greg, Your DAX didn´t totally work but I used it as a base. I needed to add an allexcep in the variables like this:
thanks!
@LuisRuiz Try this:
Measure =
VAR __Index = MAX('Table'[Index])
VAR __Year = MAX('Table'[Year])
VAR __Table = FILTER(ALL('Table'),[Index] <= __Index && [Year] = __Year)
RETURN
SUMX(__Table,[Value])
Hi Greg, Your DAX didn´t totally work but I used it as a base. I needed to add an allexcep in the variables like this:
thanks!
User | Count |
---|---|
128 | |
109 | |
100 | |
65 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |