How to get a percentage of ticket requests opened 10 days or earlier from another date

[Anonymous]

Hi,

I am trying to figure out how to get a percentage of tickets that were created 10 days prior to a new hire start date from a excel data source. 

Some new hires meet the ticket submittion of 10 days prior the start date but some don't. I need to create a DAX expression to find the percentage of # of requests created 10 days or earlier.

The fields are listed as follows. 

Ticket Number

Created

New Hire Name

Start Date

Thanks in advanced!

[Anonymous]

@tamerj1 Thank you! Now I have another question. If I want to show these two metrics for Requests (Request Number) and Tasks (Task Number)- where Requests are not unique values and Taks are unique. How can I show this?

[tamerj1]

Hi @Anonymous 
Please provide more context and perhaps some sample data along with the expected result so I can assist you further.

[tamerj1 · Accepted solution]

Hi @Anonymous 
Please use 

Percentage 10 Days or Earlier =
VAR TotalTickets =
    COUNTROWS ( TableName )
VAR Tickets10DaysOrEarlier =
    COUNTROWS (
        FILTER (
            TableName,
            DATEDIFF ( TableName[Created], TableName[Start Date], DAY ) >= 10
        )
    )
RETURN
    DIVIDE ( Tickets10DaysOrEarlier, TotalTickets )