MoM and YoY without using Lookup or table calculations

Here is the importance of the question you have eliminated using table calculations to get the relative MoM or YoY values

if you are looking for the MoM and YoY relative to a single specific date (Like today() or a parameter value) that can be done with LOD's

if you expect to see a series that includes a rolling month and you want each month in 21 to match each month in 20 then the only way left is to duplicate the data set and join it back to itself using join conditions that offset the date value by one year

it is a complex thing to do in the real world when you try you get data lined up very low levels of granularity - see the recording at https://www.youtube.com/watch?v=3xhTUmNl3Q4&list=PL_qx68DwhYA_-2lTeTpzvb7abRVy_Ufss&index=2

roughly half way through the recording I address doing YoY by joining a dataset with a copy of itself

Jim