to get month name in filter pane

[raju_r]

how to get month names in filter when  data exist.if no data month name should not appear.for exam future month name should not appear

[Aditya_Chitale]

something like this ?

Aggr(only({<date_field={"<=$(=date(today(),'M/DD/YYYY'))"}>}date_field),date_field)

Regards,

Aditya

[tresB]

One simplerer solution could be - load dates only from your fact tables

[vinieme12]

as below

=Aggr(only({<date_field={"=sum(sales)>0"}>}date_field),date_field)

replace   "=sum(sales)>0" with a measure that verifies data exists