Forum Discussion

Anja31's avatar
Anja31
Regular Visitor
3 years ago

Count IDs with filter and earliest date

Hi, 

how do I get the unique number of Case Numbers filtered to a Process Stage Type for the respective earliest creation date?

I would like to display this number in a bar chart over time.

 

Example:

 

 

Need Help

1 Reply

  • lucadelicio's avatar
    lucadelicio
    Icon for Impactful Individual rankImpactful Individual
    3 years ago

    Try to create a measure:
    MIN(TABLE[CreatedOn])
    it would return only 1 row for any case number.
    Sign as solution if i help you.