Forum Discussion
Post ProdigyNeed HELP New Customers Calculation
Hi , i make a calculation here over the New Customers . below is my calculation.
but i don't know what i'm doing here :D , i dun understand the calculation result of New Customer.
I still dun get it why New cusotmers show 1 or 2 in someday . Can somebody Explain me why ? i think for few hours still do not make any sense for me.
New Cusotmers =
VAR CustomerTM = VALUES( 'Daily Sale PC'[Customer Name - Store])
VAR PriorCusotmers = CALCULATETABLE(VALUES( 'Daily Sale PC'[Customer Name - Store] ),
FILTER(ALL('Date'),
'Date'[Date] > MIN('Date'[Date]) -30 &&
'Date'[Date] < MIN('Date'[Date] ) ) )
RETURN
COUNTROWS(
EXCEPT(CustomerTM, PriorCusotmers))
2 Replies
v-qiuyu-msftCommunity Support
Hi Chanleakna123,
You have created two temporary tables in your measure, then use the Except() function to filter the rows of CustomerTM table which do not appear in PriorCusotmers table, then count these rows.
You can understand its logic after you go through these functions:
https://msdn.microsoft.com/en-us/query-bi/dax/values-function-dax
https://msdn.microsoft.com/en-us/query-bi/dax/calculatetable-function-dax
https://msdn.microsoft.com/en-us/query-bi/dax/except-function-dax
Best Regards,
Qiuyun Yu- Chanleakna123
Hi , i make a calculation here over the New Customers . below is my calculation.
but i don't know what i'm doing here :D , i dun understand the calculation result of New Customer.
I still dun get it why New cusotmers show 1 or 2 in someday . Can somebody Explain me why ? i think for few hours still do not make any sense for me.New Cusotmers =
VAR CustomerTM = VALUES( 'Daily Sale PC'[Customer Name - Store])
VAR PriorCusotmers = CALCULATETABLE(VALUES( 'Daily Sale PC'[Customer Name - Store] ),
FILTER(ALL('Date'),
'Date'[Date] > MIN('Date'[Date]) -30 &&
'Date'[Date] < MIN('Date'[Date] ) ) )RETURN
COUNTROWS(
EXCEPT(CustomerTM, PriorCusotmers))
