Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

final value in a dataset

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

Need Help
  • v-easonf-msft's avatar
    v-easonf-msft
    6 years ago

    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

     

4 Replies

  • Pragati11's avatar
    Pragati11
    Super User
    6 years ago

    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

     

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    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. 

    \

  • v-easonf-msft's avatar
    v-easonf-msft
    Community Support
    6 years ago

    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