DAX - time graph for a measure

[Diego_Vialle]

Hello, I have a measure that adds up the billing value of customers who NEVER bought BUT BUY in the last two months.

When including the measure of the sum of these values, I cannot use the Calendar table. How do I show these measurement values of the last two months?

Below is the formula I use to show customers who NEVER bought BUT BUY in the last two months:

Qtd. Faturamento Bimestral =

VAR AllOldCustomers =

CALCULATETABLE (

VALUES ( SBOPRODMS[Nome do PN] ),

SBOPRODMS[Data NF]

< TODAY () - 60,

SBOPRODMS[Documento] = "Nota fiscal de saída"

)

VAR AllNewCustomers =

CALCULATETABLE (

VALUES ( SBOPRODMS[Nome do PN] ),

AND (

SBOPRODMS[Data NF]

< TODAY (),

SBOPRODMS[Documento] = "Nota fiscal de saída"

)

)

VAR NewCustomers =

EXCEPT ( AllNewCustomers, AllOldCustomers )

RETURN

CALCULATE (

DISTINCTCOUNT ( SBOPRODMS[Nº Documento] ),

FILTER (

SBOPRODMS,

SBOPRODMS[Nome do PN]

IN NewCustomers

&& SBOPRODMS[Documento] = "Nota fiscal de saída"

)

)

Below is the formula I use to add the value of the invoices of these customers in the table:

Soma Novos Clientes Bimestrais =

SUMX (

VALUES ( SBOPRODMS[Nome do PN] ),

IF ( [Novos Clientes Bimestrais] = 1, [Valor NET | NF] )

)

[amitchandak · Accepted solution]

@Diego_Vialle , Consider this

Customer has transaction in last 60 days

Rolling 60 = CALCULATE(sum(Sales[Sales Amount]),DATESINPERIOD('Date'[Date ],MAX('Date'[Date ]),-60,Day))

Customer do have in last 60 days

countx(values(Customer[Customer]) , if(isblank([Rolling 60]), [Customer], Blank())

refer

Customer Retention Part 5: LTD Vs Period Retention
https://community.powerbi.com/t5/Community-Blog/Customer-Retention-Part-5-LTD-and-PeriodYoY-Retentio...

Customer Retention Part 2: Period over Period Retention :https://community.powerbi.com/t5/Community-Blog/Customer-Retention-Part-2-Period-over-Period-Retenti...