show number customer 3 month ago

[daedah]

Excuse me please

I tring calculate dax measure of number of new customer 3 month ago

As picture below,

I use dax formula 

customer 3 monthago = CALCULATE(DISTINCTCOUNT('Sale_2017-2019'[CUST_ID]),'Sale_2017-2019'[status_cust]="NEW",DATEADD('Date'[Date],-3,MONTH))

but it mistake ,get result 

it should be , Thank you for your help 🙏

[nahid3152]

HI,
Create a column where ABC=DATEDIFF('Date'[Date],NOW(),MONTH)
and use it on ur function where abc < 3 .
Or
Can u share ur demo pabx with us ? Thanks

[daedah]

https://drive.google.com/file/d/1liL_LOw7xN9CoajiplRUqIvjT7DCYCnI/view?usp=sharing 

🙏

[daedah]

excuse me please

I another 1 question
I want to create measure for sumtotal separate custId in each year
example
cust id      sumtotal_2018
C0002         xxxx
C0003         xxxxx
.
.
I create measure is
cust_2018 =
SUMX(FILTER('Sale_2017-2019','Sale_2017-2019'[CUST_ID] && 'Sale_2017-2019'[BILL_DATE].[Year]=2018),[BILL_TOTAL_AMT])

but it not result

Do you have improve formula?

Thank you for your help 🙏

[nahid3152]

Hi,
For this do u have any flag or log to separate custId?
if yes use it as filter by year

[nahid3152]

Please Use this

abc 3 monthago = CALCULATE(DISTINCTCOUNT('Sale_2017-2019'[CUST_ID]),'Sale_2017-2019'[status_cust]="NEW",DATEDIFF('Date'[Date],-3,MONTH))