How many cars where delivered in 30 days after OrderDate.

[Anonymous]

I have CarSales with OrderDate and DeliveryDate.

I would like to calculate how many cars where delivered(OrderDate) in 30 days after OrderDate.
And would like to calculate how many cars where delivered in more than 30 days after OrderDate.

Then I would like to have pie chart to visualize like 30% delivered in 30 days and 70% delivered in more than 30 days.

I suppose I need create new column or measure. How?

[amitchandak · Accepted solution]

use datediff and if

https://docs.microsoft.com/en-us/dax/datediff-function-dax

date diff = datediff(order_date,delivery_date,day)

LT 30 = if([date diff]>30 ,1 ,0)
GT 30 = if([date diff]<=30 ,1 ,0)

Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks.

My Recent Blog - https://community.powerbi.com/t5/Community-Blog/Comparing-Data-Across-Date-Ranges/ba-p/823601