The following generates a parameter list with dates that are in the fact table - which is what I wanted. Now I am try to do two things. First, I'd like to get the list in descending date order. Secondly, I'd like to further restrict the
list to dates within the past 30 days while continuing to show only those dates that have corresponding fact rows.
Here is the code:
AS [Pay Date].[Date Name].CURRENTMEMBER.MEMBER_CAPTION
View Complete Post