final value in a dataset

[Anonymous]

Hello,
In the dataset below I would like to get the final value which in this dataset is 1.05 using DAX. How can I do this please?

Thank you

Dataset:

heights
---------
1.1
0.5
9.3
1.05

[v-easonf-msft · Accepted solution]

Hi , @Anonymous 

If I understand your requirement correctly that you want to get the final value of  the table in  data view,rigtht?

If it is , it is suggest  to create a index column,then  create formula as below:

final value = CALCULATE(SUM('Table'[heights]),FILTER('Table','Table'[Index]=MAX('Table'[Index])))

The result will show as below:

Best Regards,
Community Support Team _ Eason

[amitchandak]

@Anonymous , it can be max, lastnonblank value etc

Max(Table[A])

[Anonymous]

This depends greatly on which way your dataset is oriented at that very moment. maybe you can show me your usecase or some more info about your dataset. This way we can find a fitting solution. 

\

[Pragati11]

Hi @Anonymous ,

Does your dataste have just this one column or it has someother columns?

Can you paste screesnhot of your sample data please?

DAX is written using some kind of logic which I don't understand in your case.

Thanks,

Pragati