Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I have a table with weely payroll amounts by person and I need to split those amounts into daily records for each person so I can accurate allocate costs to the appropriate month.
We use a simple formula; M-F = 1.0, Sat = 0.5 and Sun =0 so each weekly amount needs to be spread over 5.5 days.
How can I take each weekly total and create 6 daily records using the factors above?
I have a date table that also includes the paycheck date for each day if that helps any.
Solved! Go to Solution.
Hi,
You may download my PBI file from here.
Hope this helps.
Hi,
Share a dataset and show the expected result.
Employee Start Date End Date Check Date Amount
John Doe 11/5/2018 11/11/2018 11/16/2018 $11,000.00
Bill White 11/5/2018 11/11/2018 11/16/2018 $5,500.00
Desired Result
Employee Date DayOfWeek Amount
John Doe 11/5/2018 Mon $2,000.00
John Doe 11/6/2018 Tue $2,000.00
John Doe 11/7/2018 Wed $2,000.00
John Doe 11/8/2018 Thu $2,000.00
John Doe 11/9/2018 Fri $2,000.00
John Doe 11/10/2018 Sat $1,000.00
John Doe 11/11/2018 Sun $ 0.00
Bill White 11/5/2018 Mon $1,000.00
Bill White 11/6/2018 Tue $1,000.00
Bill White 11/7/2018 Wed $1,000.00
Bill White 11/8/2018 Thu $1,000.00
Bill White 11/9/2018 Fri $1,000.00
Bill White 11/10/2018 Sat $ 500.00
Bill White 11/11/2018 Sun $ 0.00
Hi,
You may download my PBI file from here.
Hope this helps.
Awesome! Thanks Ashish, thus is exactly what I've been looking for.
You are welcome.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
100 | |
76 | |
74 | |
49 |
User | Count |
---|---|
146 | |
108 | |
106 | |
90 | |
62 |