Forum Discussion

mravi0712's avatar
mravi0712
New Member
8 years ago
Solved

DAX Filters Formula

HI Team,

 

I Have a table with two column.

 

Date             Values

2017/01         20.6

2017/02         17.5

2017/03         19.4

2017/12          18.5

 

I have to create a DAX measure where in i have to get the Highest date Value displayed.

Like i have to get 18.5 as the output as the 2017/12 is the highest date.

And this we get it dynamically but not hard coded value.

 

Thanks In Advance..!!!

 

 

Need Help
  • Anonymous's avatar
    Anonymous
    8 years ago

    Hi 
    mravi0712

     

    Create this measure and place in card, you will get the desired result.

    Measure = LOOKUPVALUE(Table1[Values],Table1[Date],MAX(Table1[Date]))

     

    Thanks

    Raj 

  • prateekraina's avatar
    prateekraina
    8 years ago

    Hi mravi0712,

     

    Just make sure the datatype of Date column is set to Date.
    You can use the below measure:

     

    Value = CALCULATE(
                    VALUES(Table1[ Values])
                    ,FILTER(Table1
                        ,Table1[Date] = MAX(Table1[Date]
                        )
                    ))

    Prateek Raina

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Hi 
    mravi0712

     

    Create this measure and place in card, you will get the desired result.

    Measure = LOOKUPVALUE(Table1[Values],Table1[Date],MAX(Table1[Date]))

     

    Thanks

    Raj 

  • prateekraina's avatar
    prateekraina
    Memorable Member
    8 years ago

    Hi mravi0712,

     

    Just make sure the datatype of Date column is set to Date.
    You can use the below measure:

     

    Value = CALCULATE(
                    VALUES(Table1[ Values])
                    ,FILTER(Table1
                        ,Table1[Date] = MAX(Table1[Date]
                        )
                    ))

    Prateek Raina