Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi Experts
See Sample Data - I am trying to work out the diference month on month starting at M0
My Measure give me
M0 M1 M2 M3
202 10.1 29.3 55.2
the Step M0-M1 is correct, Then its doing M0-M2 as opposed to M1-M2, and M0-M3 as opposed to M2-M3....
My Dax Measures are
1. Paydown = [Value]*[Percentage] (where i am getting the Max for the value and Percentage column)
2. Balance Paydown =
VAR _prevdate = Lastnonblank(
Filter(All('Input'[M Column]), 'Input'[M Column]>= SelectedValue('Input'[M Column])
),
[Paydown])
Return
Calculate([Paydown],'Input'[M Column]<=_prevdate)
Then a New Measure
Bal = if([Maxcolumn] = "M0", [Paydown], [Balance Paydown]-[Paydown])
Expected Result PS Calculated Column well not work as this is a subset of a bigger picture with more products
Solved! Go to Solution.
@Anonymous , Please find the attached file after signature
@Anonymous , Please find the attached file after signature
User | Count |
---|---|
94 | |
78 | |
73 | |
63 | |
60 |
User | Count |
---|---|
108 | |
100 | |
77 | |
63 | |
61 |