Learn from the best! Meet the four finalists headed to the FINALS of the Power BI Dataviz World Championships! Register now
@SillySuzy , try like
Within90DaysPurchases =
var _max = calculate(Min(Sales[OrderDate]), filter(ALLSELECTED ( Sales ), Sales[CustomerKey] = MAX ( Sales[CustomerKey] ) ))
return
CALCULATE (
COUNTROWS ( Sales ),
filter( ALLSELECTED ( Sales ),
Sales[CustomerKey] = MAX ( Sales[CustomerKey] ) &&
Sales[OrderDate] > _max &&
Sales[OrderDate] < _max + 90
) )
I appreciate your help, but I cant use Filter(), sadly.
| User | Count |
|---|---|
| 45 | |
| 35 | |
| 27 | |
| 17 | |
| 14 |
| User | Count |
|---|---|
| 62 | |
| 57 | |
| 41 | |
| 21 | |
| 20 |