Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
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,
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,
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
98 | |
78 | |
65 | |
53 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |