Business/working days MTD vs. Prior Months
I am trying to figure out how to a MTD comparison between current month and prior months.
I want to compare my February MTD results the the prior months results assuming they were at the same MTD period as my current month. Hence if I am only at the 10 business day of the current month then I want to see where I was at on the 10th business day of prior months.
Im not sure if it should done this in the ETL or beast mode, any help would be great.