Challenge #41: Analytics PayPeriodCalc

[nickjastrzebski]

Good practice with date parsing and generate rows here.

Spoiler

[gautamsawant93]

Here's my solution, this one sure took a lot of time for me. Not exactly a beginner level challenge I felt.

[garthn555]

Spoiler

My solution - pretty much the same as the original one

[joshuaburkhow]

Was able to do this with two tools!

[klyuka]

Brute force without Alteryx beauty, but logical expression.

Spoiler

D_1 - day of week of first day in a month

P_1 = 10 + iif([D_1]<6,1,0)

P_2 = 20 - [P_1]+
iif([days]>28,1,0) * iif(([D_1]=6) OR ([D_1]=7),0,1)+
iif([days]>29,1,0) * iif(([D_1]=5) OR ([D_1]=6),0,1)+
iif([days]>30,1,0) * iif(([D_1]=4) OR ([D_1]=5),0,1))

[Hannah_Lissaman]

My solution 🙂

[Treyson]

Boom! Love any chance I get to use the 'Create Rows' tool. 

[Greg_Murray]

Solution attached

[ganeshnaicker]

use this in one of the case while training hence used multiple datetime tool. Could be done using single formula tool