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 )
The order number is related to a clients name and client code, I forget to mention that sorry !
Hi @frostys
This calculated table will give you a list of your customers
Table = VAR CustomersPurchasedLast3Months = SELECTCOLUMNS( FILTER( 'Table2', EOMONTH('Table2'[Date],3)>TODAY() ), "Customer",[Controlling Customer Name]) RETURN EXCEPT( VALUES('Table2'[Controlling Customer Name]), CustomersPurchasedLast3Months )
Thank you for you respond ! @Phil_Seamark
I created this formula but I try to figure out why nothing output when I make the visualization
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 )
@Phil_Seamark, But with this solution, it will just show the customers of the last 3 months ?
I was more thinking about a dax formula who output the customer who have not orders anything from the last 3 months
Hi @frostys
My formula only shows customers who have NOT make a purchase in the last three months.
First it detects those that have made a purchase, and then uses that list to excluded recent customers from the overall list.
Hi,
Share the link from where i can download your PBI file.
Hi Ashish_Mathur,
I can not share this data.
Perhaps you know a dax function to detect the nonoccurence (of custumer) in a given time .
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
118 | |
101 | |
71 | |
61 |