Intersect Virtual Table Grand Total

DAX DAX Calculations
4

Hi @Swhs24,

Okay so I’ve put something together, see how you get on with this.
The base measure is the same and looks like this.

New Customers = 
VAR NewCustomers = VALUES(Sales[Customer Name Index] )
VAR PrevCustomers = CALCULATETABLE( VALUES( Sales[Customer Name Index] ), DATEADD( Dates[Date], -1, MONTH ))
RETURN

COUNTROWS(
    INTERSECT( PrevCustomers, NewCustomers )
)

.
Then I used measure branching to iterate over a virtual table of the Months and Years.
With this result.

image

Here’s my sample file. eDNA - New Customers with Totals.pbix (573.5 KB)
I hope this is helpful.

2 Likes