Why did I need this?
My organization uses what we call the Faculty / Staff Calendar for payroll. You can find them @ https://www.csuchico.edu/hr/calendars.shtml. Anyone notice anything odd?
...
Updated 5 years ago
Version 10.0
Blog Post
drgrd13 - I don't know if I fully understand your question.
...show me how to create an offset month, Quarter Year based on your calendar?
You can create [QuarterNum] as:
= Table.AddColumn(#"Added Custom", "QuarterNum", each if [PeriodNum] <= 3 then 1 else if [PeriodNum] <= 6 then 2 else if [PeriodNum] <= 9 then 3 else 4, Int64.Type)to get:
In my actual .pbix, I use yyyymm as an integer, [...PeriodID] to fix granularity of an annual budget to daily transactions.
Possibly you can implement the idea of using an integer to do math operations to 'offset' periods to your criteria since you can not use Built-in DateTime Functions when using custom periods?