Month over Month % Two Diferente Variables

[brunoRF]

Hello all,

I would like to have this formule (where "Y" could be Year or Month):

(Sum of total customers (y) - Sum of new customer ( y)) / Sum of Total customer (y-1)

Note: Total customer and new customer IDs comes from differente tables

Thanks a lot in advance

[v-cherch-msft]

Hi @brunoRF 

You may link the two tables and then create measures.For example:

PreviousYear_Total =
CALCULATE (
    COUNT ( Total[Total Customer ID] ),
    FILTER ( ALL ( Total ), Total[Year] = MAX ( Total[Year] ) - 1 )
)

If you need further help,please paste some data sample here or upload the .pbix file to OneDrive and post the link here. Do mask sensitive data before uploading.

Regards,

[v-cherch-msft]

Hi @brunoRF 

Could you tell me if your problem has been solved? If it is,kindly mark the helpful answer as a solution and welcome to share your own solution. More people will benefit from here. If not, please share more details for us so that we could help further on it.You can upload the .pbix file to OneDrive and post the link here. Do mask sensitive data before uploading.

Regards,