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

Helper I

## Recover the last date according to a slicer

Hello,

I am realising a power BI rapport and I am blocking on a date problem :

I have a first table which lists the different amounts for a project numero. I want to created a second table where I recover the last amount from the first table. In this example, in the second table, i would like to have 213L183301 - 616 918,53. If I select date_comptabilisation between 01/07/2020 and 31/12/2020, i would like that the second table displays 414 281.06.

Is there a way to solve this problem ?

Thank you !

1 ACCEPTED SOLUTION
Impactful Individual

I've created a measure that yields 1 or 0:

``````Max Date Filter =
VAR _MaxDate =
CALCULATE(
MAX(Table1[Date])
,ALLSELECTED(Table1[Date])
, KEEPFILTERS(Table1[Project] = SELECTEDVALUE(Table1[Project]))
)
RETURN
CALCULATE(
IF(SELECTEDVALUE(Table1[Date]) = _MaxDate,1,0)
, KEEPFILTERS(Table1[Project] = SELECTEDVALUE(Table1[Project]))
)``````

Now, add this measure to the visual's filter:

Victory!

-------------------------
Data analyst by day, hockey goalie by night.
Did I help? Then please hit that "kudos" or "accept as a solution" button!
2 REPLIES 2
Helper I

Thank you so much, it's exactly what I wanted !

Impactful Individual

I've created a measure that yields 1 or 0:

``````Max Date Filter =
VAR _MaxDate =
CALCULATE(
MAX(Table1[Date])
,ALLSELECTED(Table1[Date])
, KEEPFILTERS(Table1[Project] = SELECTEDVALUE(Table1[Project]))
)
RETURN
CALCULATE(
IF(SELECTEDVALUE(Table1[Date]) = _MaxDate,1,0)
, KEEPFILTERS(Table1[Project] = SELECTEDVALUE(Table1[Project]))
)``````

Now, add this measure to the visual's filter:

Victory!

-------------------------
Data analyst by day, hockey goalie by night.
Did I help? Then please hit that "kudos" or "accept as a solution" button!

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