Index is an actual column and Value is a measure (table below).
How can I get the result of the previous row in a new measure?
I want to use measure as this "Value' is a result of aggregation through a few visualization filters.
Go to Solution.
Could you mean to get the value in previous row? If so, you could refer to below steps:
Create below measure:
Previous row value = var a=CALCULATE(SUM(Table1[Index]))-1
You could also download the pbix file to have a view.
Share the link from where i can download your PBI file.
Thanks for your help!
Your solution gave me an idea what I've been doing wrong and it worked.
Engage and empower students with Power BI!
Continue your learning in our online communities.
Travel to Melbourne and network with thousands of peers!
Check out what's new in the Power BI Community!