List Box

[upaliwije]

Hi Friends

I have a list box in my Q doc as shown below. This list box show all the date of the periods. I want to show only Month end Date of month. Pls hlep me 

[jonathandienst · Accepted solution]

You could create a calculated dimension:

=Aggr(If(Current = Floor(MonthEnd(Current)), Current), Current)

But a better solutions to create the month end as a different field in the load script, or set a flag value for the month ends:

LOAD ...
  Current,
  Date(Floor(MonthEnd(Current)) as CurrentME,
  ...

[Brett_Bleess]

Did the poster's response get you what you needed?  If so, please be sure to click the Accept as Solution button to give them credit.  If you still need further help, please update with a new post.

Regards,
Brett