Forum Discussion

Anmolgan's avatar
Anmolgan
Icon for Post Prodigy rankPost Prodigy
6 years ago
Solved

Count distinct values that adds each month?

I want to count distinct values that gets added each month NAMES Date A1111 30-May-19 A2234 22-Jul-19 A2141 28-Jun-19 A2234 23-Jun-19 A2431 29-Jun-19 A421 13-May-19 ...
Need Help
Show and Tell
  • az38's avatar
    az38
    6 years ago

    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

az38's avatar
az38
Icon for Community Champion rankCommunity Champion
6 years ago

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

az38's avatar
az38
Icon for Community Champion rankCommunity Champion
6 years ago

Anmolgan 

share pbix if you can 🙂

 

do not hesitate to give a kudo to useful posts and mark solutions as solution

  • Anmolgan's avatar
    Anmolgan
    Icon for Post Prodigy rankPost Prodigy
    6 years ago

    I had shared the pbix with you in your private chat