Get latest rent based on slicer selection

[TriveniN]

Hi,

How to get latest rent based on slicer selection.

I had existing code and it retuns data like below and getting all data if it satisfyies below condition I mentiond in DAX, but I need to get latest SystemModstamp values(Highlighted Values in Yellow) along with below condition I mentioned in DAX .

How we can achive this?

Example : If we select 23/11/2023, we need to get below heighleted data in the screenshot1.

Example : If we select 9/11/2023, we need to get below heighleted data in the screenshot2.

screenshot1

screenshot2

Published Listings=

VAR _Date = CALCULATE(MAX(Datecalendar[TheDate]))

RETURN

CALCULATE( MAX('REVISE RENT'[Push_Rent__c]),

     Cycle_Time[Listing_Start_Date__c] <= _Date && Cycle_Time[Listing_Start_Date__c] <> Blank() &&

     (Cycle_Time[Listing_End_Date__c] = Blank() || Cycle_Time[Listing_End_Date__c] > _Date) &&

     CYCLE_TIME[MIR_Inspection_End_Date__c] <> BLANK() && CYCLE_TIME[MIR_Inspection_End_Date__c] <= _Date &&

     CYCLE_TIME[Make_Ready_Type__c] <> "Disposition" ,

    CYCLE_TIME[Make_Ready_Start_Date__c] <> BLANK() &&

    (Cycle_Time[Yardi_Sign_Date__c] = BLANK() || Cycle_Time[Yardi_Sign_Date__c] > _Date),

FILTER(ACQUIRED_PROPERTY, ACQUIRED_PROPERTY[Unit_Status__c] <> "Eviction" &&

    ACQUIRED_PROPERTY[Name] in {[ASOF_Home_Count]} &&

    NOT(ACQUIRED_PROPERTY[Name] in {[ASOF_Approved_Applications]}) &&

    NOT(ACQUIRED_PROPERTY[Name] in {[ASOF_Under_Review_Applications]}) &&

    NOT(ACQUIRED_PROPERTY[Name] in {[ASOF_Occupied_Homes]}) &&

    NOT(ACQUIRED_PROPERTY[Name] in {[ASOF_Under_Renovation]}) &&

    (ACQUIRED_PROPERTY[Disposition_Date__c] > _Date || ACQUIRED_PROPERTY[Disposition_Date__c] = BLANK()) &&

    (ACQUIRED_PROPERTY[Stabilization_Date__c] <> BLANK() || ACQUIRED_PROPERTY[Stabilization_Date__c] = BLANK())

     && Not (ACQUIRED_PROPERTY[Name] )IN {[Model homes]}) ,

    FILTER('REVISE RENT','REVISE RENT'[CreatedDate]<=_date),

     FILTER(LISTING,LISTING[List_On_Website_PL__c]="Published"))

Help me out to get it

[vanessafvg]

can you provide some sample data with how your data is related?  also what table  does SystemModstamp site?  It's much easier to solve the problem with some sample data (you can link a cloud source with your data or some sample data that doesn't affect privacy), or you can copy and paste the data as text.   However you have quite a few tables and its important to know where the SystemModstamp  sits and how that relates to the other information.  

Ideally you could get variables for your name and max SystemModstamp date < the date selected is greater and then pass that back to your dax code that you have.   but posting more information with sample data makes this easy to solve, otherwise we not getting the full picture.