Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi !
I try to make a DAX function to show clients who have no sent any orders for more than 3 months.
With this kind of data :
Thank you for your help
Solved! Go to Solution.
HI @frostys
Please try this tweak
Table = VAR CustomersPurchasedLast3Months = SELECTCOLUMNS( FILTER( 'Table2', EOMONTH('Table2'[Date],3)>TODAY() ), "Customer",[Controlling Customer Name]) RETURN EXCEPT( ALL('Table2'[Controlling Customer Name]), CustomersPurchasedLast3Months )
User | Count |
---|---|
124 | |
108 | |
99 | |
62 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |