Forum Discussion

Anonymous

Not applicable

8 years ago

Solved

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.

v-yuta-msft
8 years ago
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

Microsoft Employee

8 years ago

Will it always be the highest value? If so you could use MAX([Planned Value (Cumulative)]

Anonymous
Not applicable
8 years ago
Thank you Phil_Seamark

But in my case it is not, it depends on other values so it is not the highest vale.
- Phil_Seamark
  Microsoft Employee
  8 years ago
  Then do you have another column that is used to determine the order to get the last value? Is it a Date column or transaction ID
  - Anonymous
    Not applicable
    8 years ago
    Phil_Seamark
    No, it is not a date, it is an amount value