Variable date for datediff

[Syndicate_Admin]

Hi good morning, I'm trying to make a column where using a date selected from another table from the Report view pane.

Right now I have this:

IF(

'Total Tickets'[Request Status] IN {"Open", "Ongoing", "On hold", "Standby Provider", "On Standby User", "Postponed", "Resolved"},

IF(

'Total Tickets'[End Date] IN {BLANK()},

DATEDIFF(

'Total Tickets'[Date created],

-------------

HOUR

),

BLANK()

)

)


Where I have the dashes in the datediff is where I need to put the variable date that I can select from the report view.

If I need any more information to be able to help, I can provide it.

[Syndicate_Admin]

Hi @Syndicate_Admin I try it and let you know if it has worked for me


Thank you!

[Anonymous · Accepted solution]

Hi @Syndicate_Admin ,
Here some steps that I want to share, you can check them if they suitable for your requirement.
Here is my test data:
Total tickets

Time

Create measure

Datediff = 
IF(
    SELECTEDVALUE('Total Tickets'[Request Status]) IN {"Open", "Ongoing", "On hold", "Standby Provider", "On Standby User", "Postponed", "Resolved"},
    IF(
        SELECTEDVALUE('Total Tickets'[End Date]) IN {BLANK()},
        DATEDIFF(
        SELECTEDVALUE('Total Tickets'[Date created]),
        SELECTEDVALUE('Time'[Another date]),
        HOUR
    ),
    BLANK()
    )
)

Final output

Best regards,

Albert He

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

[Syndicate_Admin]

Perfect, works properly, thank you!