AVG New Customer Spend - DAX
Hi, I need to calculate the average spend for new customers in the previous month. However, it needs to be only for customers that have had at least 2 visits in that previous month. Formula: Spend of new customers with >=2 visits in previous month / no. of new customers with >=2 visits in previous month Fact table below - it also has a column for spend Fact table: Date dimension is joined on visit date. New customer is defined by their reg date. So the dax should count customers that registered and had two visits in the previous full month. From the above, only customer 1 should be counted, as customer 2 didn't have a registration date in the previous month. Any help would be appreciated. Thanks!I want to take the average of the last 3 years of the total number on a monthly and yearly basis
Hi, I have a table like this. And I want to get the second table from this table. I try to use the rollup and sum functions with the filter but I can't find any solution for getting the right amount written in the table to show in a graphic. I wrote something like this but I should get also the next 3 years and the next three years till last year. Summary last 3 years = SUMMARIZE('Summary Incident Yearly' , ROLLUP(ROLLUPGROUP('Summary Incident Yearly'[Country],'Summary Incident Yearly'[MAAND])) , "3 years AVG", CALCULATE( SUM('Summary Incident Yearly'[amount])/3 ,FILTER('Summary Incident Yearly', 'Summary Incident Yearly'[JAAR]>=2015||'Summary Incident Yearly'[JAAR]<=2017)) , "Jaartaal", "15/16/17") JAAR MAAND Country amount 2015 1 Netherlands 1082 2015 1 Belgium 174 2015 1 Belgium 8 2015 1 Luxembourg 1 2015 1 Suriname 15 2015 2 Netherlands 1181 2015 2 Belgium 212 2015 2 Belgium 5 2015 2 Luxembourg 2 2015 2 Suriname 5 2016 1 Netherlands 1244 2016 1 Belgium 259 2016 1 Belgium 23 2016 1 Luxembourg 1 2016 1 Suriname 2 2016 2 Netherlands 1252 2016 2 Belgium 264 2016 2 Belgium 19 2016 2 Luxembourg 2 2016 2 Suriname 4 2017 1 Netherlands 1088 2017 1 Belgium 243 2017 1 Belgium 17 2017 1 Luxembourg 4 2017 2 Netherlands 1054 2017 2 Belgium 288 2017 2 Belgium 15 2017 2 Luxembourg 2 2017 2 Suriname 5 AVG JAAR Maand Country AVG 15/16/17 1 Netherlands 1138 15/16/17 1 Luxembourg 2 15/16/17 1 Belgique 120 15/16/17 2 Netherlands 1162 16/17/18 1 Netherlands etc 16/17/18 1 Luxembourg etc And at the end I will get a graphic like this : Thank you for your help
