Forum Discussion
Last Column Value
Dears, Have a good day. I need to get the last value of a column, just read it without calculation as the value is a cumulative value.
Hi aserag,
In your scenario, you want to achieve the value in the last row, right? For example, 54545 is what you want in column [Planned value] below.
The first solution is that you can create an index and use the max index to find the value, click Query Editor->Add Column->Index Column.
After applied, you can create a measure using DAX formula:
last value = CALCULATE(MAX(Table1[Planned Value]), FILTER(Table1, Table1[Index] = MAX(Table1[Index])))
The second solution is that you can simply use “Keep Bottom Rows” to achieve last value.
Regards,
Jimmy Tao
What if I want to take the last 5 elements insted of just one?