Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

New Customer Volume

Hello - 

 

I have created the below measure for New Customer Count, but for some reason I am having issues creating New Customer Volume branching off of this measure.  Can someone help me out with this.  I have a feeling it is a simple branch off of my below DAX but I am not sure.

 

Thanks

Ryan

 

New Customer Count = 
COUNTROWS (
    FILTER (
        ADDCOLUMNS (
            VALUES ('FINAL Asset Report'[Cust Account ID]), 
            "PreviousSales", 
                CALCULATE (
                    COUNTROWS ( 'FINAL Asset Report'),
                    FILTER (
                        ALL ( Dates ),
                       YEAR(Dates[Date]) < 2017
                    )
                )
        ),
        ISBLANK ( [PreviousSales] )
    )
)
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Hi Anonymous,

     

    For your requirement, you can create two variables.
    One store previous year to past(date <=2016), other store current year to past.(date <=2017). Then use except function to compare these variable to get new records.
    For example: except(variable'2017',variable'2016')

     

    BTW, it will be help if you share some sample data for test.

     

    Notice:

    1. Please do mask sensitive data before sharing.
    2. I attached pbix file who contains similar formulas I wrote before.

     

     

    Regards,
    Xiaoxin Sheng