DAX Filters Formula

[mravi0712]

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..!!!

[rajendran · Accepted solution]

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 · Accepted solution]

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

[rajendran · Accepted solution]

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