Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Identify New Business DAX

Hi,   I am trying to identify new business between certain months this year and certain months the previous year   for example   October 2016 to September 2017 + October 2015 to September 201...
Need Help
Anonymous's avatar
Anonymous
Not applicable
8 years ago

Hi v-caliao-msft,

 

Thanks for that,

 

There needs to be some comparisons between the True COmpany field though so I need to say if this company was found last year it is not new business?

 

Thanks

 

Chris

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    I came across this pattern online

     

    [New Customers] := 
COUNTROWS (
    FILTER (
        ADDCOLUMNS (
            VALUES ( Sales[CustomerKey] ),
            "PreviousSales", CALCULATE (
                COUNTROWS ( Sales ),
                FILTER (
                    ALL ( 'Date' ),
                    'Date'[FullDate] < MIN ( 'Date'[FullDate] )
                )
            )
        ),
        [PreviousSales] = 0
    )
)

     

     

    How would I go about amending it to say if customer didnt buy oct15-sept 16 but bought oct16 - sep17 it is a new customer..