Supplies are limited. Contact info@espc.tech right away to save your spot before the conference sells out.
Get your discountScore big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount
Can someone please give me a quick explaination on why I can't use my [NextMonth] in the DateAdd funtion.
EVALUATE
ADDCOLUMNS (
SUMMARIZE (
Customers,
Customers[CustomerKey],
Customers[DateFirstPurchase],
"Second Purchase",
CALCULATE (
FIRSTDATE ( Sales[OrderDate] ),
FILTER ( Sales, Sales[OrderDate] > Customers[DateFirstPurchase] )
),
"90 Day Date After First Purchase", Customers[DateFirstPurchase] + 90,
"NextMonth", ENDOFMONTH ( Customers[DateFirstPurchase] ) + 1
),
"Next3Months", DATEADD ( [NextMonth] , 3, MONTH ),
"Within 90 Days",
IF (
[Second Purchase] > [DateFirstPurchase]
&& [Second Purchase] <= [90 Day Date After First Purchase],
"Yes",
"No"
)
Solved! Go to Solution.
User | Count |
---|---|
12 | |
12 | |
8 | |
8 | |
6 |
User | Count |
---|---|
27 | |
19 | |
14 | |
11 | |
7 |