Forum Discussion
sorting a date table chronologically
Is that what you want to see as result? If yes, simply add to your Date Dim couple column:Month & Year = FORMAT([Date], "MMM" & " " & "YYYY") and Sort = FORMAT([Date], "YYYYMM") ; define "Sort by Column" accordingly it will give you correct sequence.
You are a genius! Thanks so much, that worked exactly the way I wanted it.
You would likely need to have a proper date column and you could use "Sort By" to sort your original month/year column by the date column.
I have a proper date column but using it as a page filter gives me a list of every day of every month and I only have one data point per month (the valuation date) that I want to capture. When I put the date column into the filter I therefore get a whole load of unnecessary dates. As an alternative I have tried using Month from my date table (Month Year) but that filter doesn't appear to filter chronologically.
Do you have a Sort column for your (Month Year) column? Something like FORMAT([your date key],"YYYYMM")?
I think that you have misunderstood. I have a date table with date, day, dayofmonth, dayofweek, month, monthofyear,ordinaldate, quarter, quarterfoyear, weekending, year. When I put the date column into the page level filter it gives me every day of every month of every year, but I only want one data point each month (my valuation date which is the last working day of each month). As an alternative I tried using Month = FORMAT([Date]; "MMM") & " " & [Year] but when that goes into the page level filter, it does not sort chronologically. I am trying to figure out how I can either remove all the dates that arenn't a valuation date in a month so that it can be used a page fillter or sort the Month column in the page level filter chronologically