show number customer 3 month ago

[daedah]

Excuse me please

I tring dax formula for calculate number of customer 3 month ago

As picture below

I use formula 

new cust 3 month age = CALCULATE(DISTINCTCOUNT('Sale_2017-2019'[CUST_ID]),'Sale_2017-2019'[status_cust]="NEW",DATEADD('Date'[Date],-3,MONTH))

But it mistake ,I get result

I should be improve it

Thank you for your help 🙏

[v-diye-msft · Accepted solution]

Hi @daedah 

I'd suggest you convert the Month as a number : 1,2,3,4...

Then use below measure:

Measure = var a = MAX('Table'[Month])-3
Return
IF(MAX('Table'[Month])<=3,BLANK(),CALCULATE(MAX('Table'[Values]),FILTER(ALL('Table'),[Month]=a))
)

[nahid3152]

HI,
Create a column For DATEDIFF where date convert to month
ABC=DATEDIFF(Date'[Date],NOW(),MONTH)
Then use it in a condition where ABC < 3 or ABC > 3 what ever ur need.

OR share some demo pabx file