Forum Discussion
Relative time measures
Hello all, I'm trying to do a SWITCH for Time Periods but my Calendar its not standard, some month don't start at Day 1 not do they end at the 30/31, they start at the first Monday of the week th...
You might want to take a look at Power Query to help you solve this problem; creating a custom period(s) calendar table. http://cjmendoza.yourweb.csuchico.edu/custom-calendar/create-a-custom-period-calendar-in-power-query/ provides some context for what I purpose.
Thanks for the reply ChrisMendoza !
As I mentioned, I already have the PeriodStart and PeriodEnd columns in my Dim Calendar but I just can't seem to make the switch calculate using those periods...
Any thoughts?
Thanks in advance,
Tiago
