Count of different new species

[Victorybarzo]

Good afternoon all!

I have a table (excel sheet) that contains daily data of observed animal species. I need to create (dax or m language) formula that identifies, for each month, the number of species that were observed for the first time, other words, New observed species. I believe the best way is to crate a measure, but i'm not sure.

I've tried several ones, including chat gpt and other AI tips, but was not successfull with them.

Thank you!

[v-jialongy-msft · Accepted solution]

Hi @Victorybarzo 

Based on your needs, I have created the following table.

You want to observe new species every month, you can put the month into the slicer and put the following dax formula into the card visual.

Measure = DISTINCTCOUNT('Table'[animal])

This is the result you want

Best Regards,

Jayleny

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[lucadelicio]

Can you upload the pbix file?
You can upload it on https://wetransfer.com/
Thank you.

[Victorybarzo]

Oh, sorry, i have more than one line for each Day, because several species are observed per Day.