Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
mravi0712
New Member

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

 

 

2 ACCEPTED SOLUTIONS
Anonymous
Not applicable

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 

View solution in original post

prateekraina
Memorable Member
Memorable Member

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

View solution in original post

2 REPLIES 2
prateekraina
Memorable Member
Memorable Member

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

Anonymous
Not applicable

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 

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.