Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.
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 November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.