Minimum date in table( set analysis )

[KrazVerty]

Hi,everyone
I'm beginner
I have a date in my table as a dimension
I want to keep only the minimum values in the table( yellow)
and remove(exclude) the red ones,because I want to count values at the beginning of the month

how can i do that ?

[MayilVahanan · Accepted solution]

Hi @KrazVerty 

Try like below

=Count({<Date= {$(=Chr(39)&Concat(Distinct Aggr(Min([Date]),MonthYear),Chr(39)&','&Chr(39))&Chr(39))}>}Values)

Hope you have MonthYear field in ur data model, else, bring it out 

Load Date, MonthName(Date) as MonthYear from source;

[KrazVerty]

Thanks a lot !
Your  reply helped me

[MayilVahanan]

Hi @KrazVerty 

Can you close the thread.