Forum Discussion
Custom Pay Periods
Hi All, I have something i can't seem to figure out. I have a dates table with contiguous dates and i need to create a custom column that returns pay periods. My requirements are: 1. i...
Here's a file with how to do this in PQ:
https://1drv.ms/u/s!ApyQEauTSLtO6nGYmYQ4K0OFuPrz?e=t0U3yk
Bear in mind, though, that you've not given any rule as to what should happen when the calendar ends...
Best
Darek
Hi Anonymous,
Sorry i'm still learning Power BI and this is really complex for me to grasp. Could I ask, how would i even do it in Power Query and why? Is it not possible to just manipulate the formula above? I thought this was a DAX issue as i have the base measure already that's returning a custom column?
I was using datesbetween function to return 14 days from whichever monday the date falls on but i keep getting an error. Is that the correct function to be using?
Thanks
No, this should NOT be done in DAX (even if this is possible). Calculated columns do not compress well, first of all, and DAX is a Data Analysis Expression language (for calculations), not a data mashup language. M is a data mashup language.
Best
Darek
Best
Darek