Find the difference between two dates incorporating a deadline date

Hi lennox25 

You can import those tables to power query and merge between them:

extract from the string of deadlines only the number of dates :

modify data type to number

And add it to the sales date with a custom column

modify a result as a date data type

uncheck the option load to the model at the deadlines table ( you don't need it inside)

Pbix is attached

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

Hi lennox25 
You can create 3 measures : "
1.

2 

over_deadline = CALCULATE([total_transactions],FILTER(sales,[over deadline days]<0))

3 

%_over = divide ([over_deadline],[total_transactions])

+ Format it as percent

The updated pbix is attached

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

Hi lennox25 
Add a measure :

in_deadline % = 1-[%_over]

The updated pbix is attached

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