Revenue over last 3 months

[orihait]

hi guys,

got a questions for you.

i have a revenue table and a dim date table, both are connected.

rev table looks something like this :

client|date|revenue

i want to know which client hasnt made a transaction over the last 3 months buy cant find the correct syntax.

hopefully someone can help 🙂

thanks!!!

[amitchandak]

Try something like this

Rolling 3 = CALCULATE(sum(Table[Revenue]),DATESINPERIOD('Date'[Date Filer],MAX(Table[Date]),-3,MONTH)) +0

and use with show rows with no on client

[Mariusz · Accepted solution]

Hi @orihait 

Try the below Measure or the attached file.

Measure = 
VAR __clientWithSales =
    CALCULATETABLE(
        VALUES( 'Table'[client] ),
        DATESINPERIOD( 'calendar'[Date], TODAY(), -3, MONTH )
    )
RETURN 
COUNTROWS(
    EXCEPT( 
        VALUES( 'Table'[client] ),
        __clientWithSales
    )
)

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.
LinkedIn

[orihait]

thank you so much 🙂