Forum Discussion
datediff and a slicer
Hi I have a table Visits with Customer ID (Customer ID FK] and multiple customer visits with visit date (Start Date). This measure works beautifully when there is no date slicer on the report. It b...
Thaanks amitchandak.
I applied this but the message I have now is, the expression specified in the query is not a valid table expression.
CustomerRelationship = AverageX(
SUMMARIZE(Visits,Visits[Customer ID FK], "_Relationship",DATEDIFF(min(Visits[Start Date]),selectedvalue(TableDate[Day Date]),DAY)), [_Relationship])