Forum Discussion

ashu131813's avatar
ashu131813
New Member
3 years ago

New and Repeat Customers using DAX

Hi All,

I have a query regarding the DAX.I need to calculate new Customers yearly.For that I used this DAX Query -

New customers = 
VAR currentCustomers = VALUES('Sales table'[customer])
VAR currentDate = MIN('Sales table'[date])

VAR pastCustomers = CALCULATETABLE(VALUES('Sales table'[customer]), 
    ALL('Sales table'[date].[Month],'Sales table'[date].[MonthNo],'Sales table'[date].[Year])
    , 'Sales table'[date]<currentDate)

VAR newCustomers = EXCEPT(currentCustomers,pastCustomers)
RETURN COUNTROWS(newCustomers)

 

Reference::- https://blog.finance-bi.com/power-bi-new-and-repeat-customers/

But I want to filter only those Customers who came from certain region ie I want to add Filter in the above query like
FILTER(Geo_Data, Geo_Data[Region] IN {
"East",
"North-East",
"North"
}
)

 

 

Is there any way to do this thing?

1 Reply