Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! It's time to submit your entry. Live 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 |
|---|---|
| 50 | |
| 42 | |
| 36 | |
| 31 | |
| 28 |
| User | Count |
|---|---|
| 139 | |
| 128 | |
| 60 | |
| 59 | |
| 57 |