How can I get the % of change between 2 date columns?

[Anonymous]

I have 2 date columns in which I'm trying to get the difference between them as a percent, here are the columns 

[v-yanjiang-msft]

Hi @Anonymous ,

Is your problem solved? If so, would you mind accept the helpful replies as solutions? Then we are able to close the thread. More people who have the same requirment will find the solution quickly and benefit here, thank you!

Best Regards,
Community Support Team _ kalyj

[v-yanjiang-msft]

Hi @Anonymous ,

According to your description, here's my solution.

Diff =
IF ( [InvoiceDate] > [OrderShipRequestDate], 0, 1 )

Then put the Diff column in a visual and select Average in the option.

I attach my sample below for your reference.

Best Regards,
Community Support Team _ kalyj

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

[Anonymous]

So it's true I do understand the logic, why is it that when I try that formula, I can't select those columns 

[v-yanjiang-msft · Accepted solution]

Hi @Anonymous ,

Sorry for late back. Did you do it in a measure? If so, you should create a calculated column instead of a measure.

When you enter the Brace "[", all columns will appear automatically, directly choose the column in the list instead of entering the column name.

Best Regards,
Community Support Team _ kalyj

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

[Anonymous]

Trying to calcualte the average amount of orders shipped on time. If invoice date > ordershiprequestdate then it's late = 0 else 1, then find the average of that as a whole. @amitchandak 

[amitchandak]

@Anonymous ,what you mean by % change between two date ?

The information you have provided is not making the problem clear to me. Can you please explain with an example.

Appreciate your Kudos.