Forum Discussion

brunoRF's avatar
brunoRF
Frequent Visitor
7 years ago

Month over Month % Two Diferente Variables

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

Need Help

2 Replies

  • v-cherch-msft's avatar
    v-cherch-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    7 years ago

    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's avatar
      v-cherch-msft
      Icon for Microsoft Employee rankMicrosoft Employee
      7 years ago

      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,