DAX Calendar Pay Periods

Question

I have the following calendar imported into DAX; how can I custom write new columns that indicate pay period number for each specific year? For example a starting range that can go both forwards and backwards would be Payperiod Begininning Date = 01/09/2021 and the end of it was 1/22/2021. How can I write this to where I can have a column that shows the pay period number to side?

auaero · Answer

You could probably figure out a way to do this with DAX, assuming that your pay periods are always two weeks.&nbsp; I even started trying to figure it out, but then I asked "If I were solving this problem myself, how would I do it?"&nbsp; Honestly, it's probably faster and easier to either:Bang out a calendar table inclusive of your pay period column in Excel and then copy the calendar table into your data model, orCreate a table in your data model to define the pay periods and merge it to your existing calendar table in Power Query (assuming your calendar table isn't defined by DAX)