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.
I have a dataset of columns (Index & Step 1)
I am trying to achieve the below calculations for Step 2 and Final
Any suggestions? Thanks
Solved! Go to Solution.
@tamerj1 I attempted to replace the index row value from the matrix to Month-Year column (Sept 2022, Oct 2022, ...) - Now the numbers are not accurate, does this only work with index?
Hi @mo1988
Please refer to attached sample file with the solution
Step 2 =
VAR CurrentIndex = 'Table'[Index]
VAR TableBefore = FILTER ( 'Table', 'Table'[Index] < CurrentIndex )
VAR P1 = COUNTROWS ( TableBefore ) + 1
RETURN
SUMX (
TableBefore,
VAR X = 'Table'[Step 1]
VAR P = P1 - 'Table'[Index]
RETURN
( 0.5 ) ^ P * x
)
Step 3 = 'Table'[Step 1] + 'Table'[Step 2]
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
22 | |
7 | |
6 | |
6 | |
6 |
User | Count |
---|---|
27 | |
12 | |
10 | |
9 | |
6 |