cancel
Showing results 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

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.

2 ACCEPTED SOLUTIONS
Anonymous
Not applicable

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

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

Thanks

Raj

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

2 REPLIES 2
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

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

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

Thanks

Raj

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

#### Power BI Monthly Update - August 2024

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

#### Fabric Community Update - August 2024

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

Top Solution Authors
Top Kudoed Authors