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
JbPa33
Helper I
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 : 

JbPa33_1-1649056354538.png

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
rbriga
Impactful Individual
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!Victory!

 

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

View solution in original post

2 REPLIES 2
JbPa33
Helper I
Helper I

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

rbriga
Impactful Individual
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!Victory!

 

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

Helpful resources

Announcements
Europe Fabric Conference

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.

AugPowerBI_Carousel

Power BI Monthly Update - August 2024

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

August Carousel

Fabric Community Update - August 2024

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