Dynamically Determine Rental Status

DAX DAX Calculations
4

Hello @mkaess,

Thank You for confirming the scenario.

Below is the measure provided alongwith the screenshot of the final results for the reference -

Fleet On Rent - Harsh = 
VAR _Fleet_On_Rent = 
CALCULATE( COUNTROWS( 'factRental Line' ) , 
    FILTER( VALUES( 'factRental Line'[On-Rent Date] ) , 
        'factRental Line'[On-Rent Date] <= MAX( dimDates[Date] ) ) , 
    FILTER( VALUES( 'factRental Line'[Off-Rent Date] ) , 
        OR( 
            'factRental Line'[Off-Rent Date] >= MIN( dimDates[Date] ) ,
            ISBLANK( 'factRental Line'[Off-Rent Date] ) ) ) )

VAR _Results = 
IF( ISBLANK( _Fleet_On_Rent ) ,
    0 , 
    1 )

RETURN
_Results

Final Results
Final Results1199×768 44 KB

I’m also attaching the working of the PBIX file as well as providing few of the links of the blog posts as well as video links from the EDNA YouTube channel on this topic.

Hoping you find this useful and meets you requirements that you’ve been looking for. :slightly_smiling_face:

Thanks and Warm Regards,
Harsh

Fleet On Rent - Harsh.pbix (967.5 KB)

2 Likes