Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi all,
does any one know what can i do calculate the last value of a row? I have created a matrix where is constanly changing WoW, in columns I have the week when I get the data and in rows I have the weeks that are being affected. for example in the SS below I want to add a mesure to calculate what would be the last value in the row of March 2nd which would be 11790, how can I do that?
Solved! Go to Solution.
So perhaps something like:
Max Week Received Phr =
VAR __Week = MAX('Sheet1'[Week])
VAR __Table = FILTER(ALL('Sheet1'),[Week] = __Week)
VAR __MaxWeekReceived = MAXX(__Table,[Week Received])
RETURN
MAXX(FILTER(__Table,[Week Received] = __MaxWeekReceived),[Phr])
Sample data as text always helps to test. The above code is not tested. Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
So perhaps something like:
Max Week Received Phr =
VAR __Week = MAX('Sheet1'[Week])
VAR __Table = FILTER(ALL('Sheet1'),[Week] = __Week)
VAR __MaxWeekReceived = MAXX(__Table,[Week Received])
RETURN
MAXX(FILTER(__Table,[Week Received] = __MaxWeekReceived),[Phr])
Sample data as text always helps to test. The above code is not tested. Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
thank you Greg, I just tested the code you shared and it works perfectely. exactly what I was looking for.
thank you once again for your help. 😀