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

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