Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.
Hi,
would like to know if this possible in pbi to work
example:
this is for Accrued 13th month
dated Jan 10-Jan 15,2022
hire date Jan 10,2022 cutoff every 15/30or31 the month
30000(salary) / 21.5(working days) = 1,395.35 (salary per day)
1,395.35 x 5(working days before cutoff) = 6,976.74
6,976.74 / 12 = 581.40
dated Jan 16-31, 2022 half cutoff
30000 / 12 = 2500
2500 / 2 = 1250
output: 581.40 + 1250 = 1831.40
thankyou
@Easley06 , You can use networkdays or business hour logic as per need
Business day with and without using DAX Function NETWORKDAYS: https://www.youtube.com/watch?v=Qs03ZZXXE_c
https://exceleratorbi.com.au/calculating-business-hours-using-dax/
User | Count |
---|---|
15 | |
9 | |
8 | |
6 | |
5 |
User | Count |
---|---|
29 | |
18 | |
15 | |
7 | |
6 |