Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 ?
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;
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;
Thanks a lot !
Your reply helped me
Hi @KrazVerty
Can you close the thread.