Calculating the time lapsed between latest transaction and the previous transaction

[MCLR]

Can any one help me, please, to identify which accounts have started trading again, after a >12-month period  of inactivity? We want to reward our sales team not just for new accounts, but also for re-engaging with existing ones.

[Anonymous]

Would be great if you can post some sample data along with the expected result.

[MCLR · Accepted solution]

Actually, I think I am getting there with this:

Weeks Between Transactions =

VAR ThisTranDate =

SELECTEDVALUE ( 'PowerBi_Sales_Info'[InvoiceCreditDate] )

VAR PrevDate =

CALCULATE (

MAX ( 'PowerBi_Sales_Info'[InvoiceCreditDate] ),

FILTER ( ALL ( 'PowerBi_Sales_Info'[InvoiceCreditDate] ), 'PowerBi_Sales_Info'[InvoiceCreditDate] < ThisTranDate )

)

RETURN

DATEDIFF ( PrevDate, ThisTranDate, DAY ) / 7

This gives me the weeks between transactions; now I think I just need to filter out the old transactions

[Anonymous]

Glad that you are able to do it on your own! Kudos to you.

Thanks
Raj