Multi days (date/time) rental daily revenue

DAX DAX Calculations
4

Hello @JoseMilhazes,

So to achieve the results as per the third condition that you’ve specified wherein your customers don’t want to pay for an entire day but want to pay proportionally. Below is the new measure alongwith the screenshot of the final results provided for the reference -

Hire Days - 2 = 
IF( ISINSCOPE( 'Hire Log - Data'[Pick Date] ) , 
    IF( ISBLANK( SELECTEDVALUE( 'Hire Log - Data'[Delivery Date] ) ) , 
        FIXED( ( TODAY() + TIME( 23 , 59 , 59 ) ) -
               ( SELECTEDVALUE( 'Hire Log - Data'[Pick Date] ) + SELECTEDVALUE( 'Hire Log - Data'[Pick Time] ) ) , 
            4 , 
            0 ) ,
        FIXED( ( SELECTEDVALUE( 'Hire Log - Data'[Delivery Date] ) + SELECTEDVALUE( 'Hire Log - Data'[Delivery Time] ) ) -
               ( SELECTEDVALUE( 'Hire Log - Data'[Pick Date] ) + SELECTEDVALUE( 'Hire Log - Data'[Pick Time] ) ) , 
            4 , 
            0 ) ) , 
    BLANK() )

Logic for measures - “Daily Rate” and “Total Revenue” revenue remains the same.

Final Results
Final Results1150×466 42.1 KB

I’m also attaching the working of the Excel File (wherein you can cross-verify my Hire Days calculation) and PBIX file for the reference purposes.

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

P.S.:- I did posted the solution about 9 hours ago but really don’t know why the post didn’t came through or didn’t got uploaded.

Thanks and Warm Regards,
Harsh

Hire Log - Data - Harsh.xlsx (9.7 KB)

example - Harsh v2.pbix (140.0 KB)

2 Likes