Forum Discussion
Solved
Calculate Average Days for First Order (For All Customers)
Hi everyone, I am having troubles creating this measure in Power BI. The dataset I am connected to is DirectQuery. Please see image below for reference. I want to create a measure which a...
Ok I hope this will work
Days To First Order = AVERAGEX ( VALUES ( CUSTOMER[Cust ID] ), VAR DateCreated = CALCULATE ( MAX ( CUSTOMER[Cust Date Created] ) ) VAR FirstOrderDate = CALCULATE ( MIN ( ORDERS[Order Date] ), ORDERS[Order Type] IN { "A", "B" } ) RETURN DATEDIFF ( DateCreated, FirstOrderDate, DAY ) )
Hi tamerj1 ,
Okay so now the individual numbers are back to correct values, but the average still seems to be an issue. Please see the image below:
Thank you once again for your input on this.
Kind Regards
Ok I hope this will work
Days To First Order =
AVERAGEX (
VALUES ( CUSTOMER[Cust ID] ),
VAR DateCreated =
CALCULATE ( MAX ( CUSTOMER[Cust Date Created] ) )
VAR FirstOrderDate =
CALCULATE ( MIN ( ORDERS[Order Date] ), ORDERS[Order Type] IN { "A", "B" } )
RETURN
DATEDIFF ( DateCreated, FirstOrderDate, DAY )
)Hi tamerj1 ,
Just tried this and yes this works perfectly well !
Thank you for your amazing support on this !
Regards