Forum Discussion
Post ProdigyCount distinct values that adds each month?
Community ChampionHi Anmolgan
please, demonstrate to us your desired output to help you
thx
do not hesitate to give a kudo to useful posts and mark solutions as solution
Post Prodigyaz38 I need to find what are the number of Names that gets added each month, now if I create a table visual in powerbi using month and names as Distinct Count, it will show me overall customers that keeps on increasing for example:
| AUG | 100 |
| SEP | 150 |
| OCT | 200 |
| NOV | 201 |
if you look above, count keeps increasing now I need to find added customers so i need the below output:
| month | count distinct of names | added names each month |
| AUG | 100 | 100 |
| SEP | 150 | 50 |
| OCT | 200 | 50 |
| NOV | 201 | 1 |
I hope that I was able to explain you?
- az38
Hi Anmolgan
you can create a calculated table
Table 2 = SUMMARIZE('Table';'Table'[NAMES];"First appear";MIN('Table'[Date]))then in visual set date hierarchy items Year and Month to display
do not hesitate to give a kudo to useful posts and mark solutions as solution
- Anmolgan
az38 I need to find the subtraction of previous month count with the current month count for example:
month count distinct of names AUG 100 SEP 150 the above I have but I want to know how many of the count added on September that is 150-100=50, this I want to do for all the months of any year.
- Anmolgan
Something is wrong in my case, I have used your formula, if you look at the Actual Count is the count that keeps on increasing each month, and the Count GRS Name is what I have build according to your DAX measure, the subtraction should be correctly performing if I am correct, and I have build Many 2 Many relationship between the custom table and the master tables, do let me know if you need the pbix file.
- az38
share pbix if you can 🙂
do not hesitate to give a kudo to useful posts and mark solutions as solution
- Anmolgan
I had shared the pbix with you in your private chat