Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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]
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
Check out the May 2024 Power BI update to learn about new features.
User | Count |
---|---|
71 | |
43 | |
21 | |
21 | |
14 |
User | Count |
---|---|
124 | |
42 | |
39 | |
28 | |
24 |