The screenshot attached is self - explanatory
No it is not. It doesn't explain anything to me.
How is the selection of MOM, QOQ or YOY related to the sorting of dates? You can sort a date numerically in ascending or descending order or if you want to be silly you can sort it as text A-Z or Z-A. I never heard of a MOM or QOQ sorting.
Okky, my bad. Let m explain. MOM refers to dates combined as Months, QOQ refers to Quarters and YOY refers to Years.
Year(DateKey) as Year,
Month(DateKey) as Month,
Day(DateKey) as Day,
ApplyMap('QuartersMap', month(DateKey), Null()) as Quarter
So if i have selected MOM then my dates are combined as Months( 12 in a year). Here i can choose a single month( say April) which is reflected in the bar chart with sales for April. I can also select YOY in the other filter pane(To) and then i would get all Years in another filter pane, here i can select 1 year to get aggregated sales data in bar chart for 1 year i.e for eg say 2015. This will help me do Month To Year comparison.( April 2015 to whole of 2015)