Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers. Get Fabric certified for FREE! Learn more
Hi there, looking for a bit of help adding in a "Pay Period Beginning" column to my Date table. The company's pay periods are 1-15th, and 16th-end of month. So if the date in the date table is 6/10/2022, "Pay Period Beginning" would be 6/1/2022, and if it's the 24th of the month the "Pay Period Beginning" would be 6/16/2022. I'm sure this is simple and I'm overthinking it, any help is appreciated.
Solved! Go to Solution.
Give this a try.
Pay Period Beginnging =
VAR _Day = DAY ( [Date] )
RETURN DATE ( YEAR ( [Date] ), MONTH ( [Date] ), IF ( _Day <= 15, 1, 16 ) )
Give this a try.
Pay Period Beginnging =
VAR _Day = DAY ( [Date] )
RETURN DATE ( YEAR ( [Date] ), MONTH ( [Date] ), IF ( _Day <= 15, 1, 16 ) )
Beautiful, worked perfectly. Thank you so much.
Check out the April 2025 Power BI update to learn about new features.
Explore and share Fabric Notebooks to boost Power BI insights in the new community notebooks gallery.
User | Count |
---|---|
107 | |
68 | |
48 | |
44 | |
44 |