I want who are the customers continuing with organization and who are not ? from last n years

[Efftronics]

I have a list of customer details like customer name, Order date, ordered products. I want who are the customers continuing with organization and who are not ? from last "n" years based on order date.

where "n" based on selection.

[v-henryk-mstf]

Hi @Efftronics ,

I think the reference provided by @Samarth_18  is helpful.

If there are still problems, whether you can provide a test data model (delete sensitive information) and specific needs, I will answer you as soon as possible.

Best Regards,
Henry

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Samarth_18 · Accepted solution]

Hi @Efftronics 

You can create a custom table with below code for putting it as slicer to filter data based on last n years:-

year_counts = 
var total_years = YEAR(MAX(customer_details[order_Date])) - YEAR(MIN(customer_details[order_Date]))
return GENERATESERIES(1,total_years,1)

This will give you number of years based on available data

Now you create a measure with below code to filter your customer details:-

filter_last_n_year =
VAR selected_year =
    SELECTEDVALUE ( 'Table 3'[NumberOfYear] )
RETURN
    IF (
        YEAR ( MAX ( customer_details[order_date] ) ) <= YEAR ( TODAY () )
            && YEAR ( MAX ( customer_details[order_date] ) )
                >= ( YEAR ( TODAY () ) - selected_year ),
        1,
        0
    )

Use it as visual level like below:-

It would be better if you could share some sample data with expected output. So that people can provide you more precised solution.

Thanks

Samarth