Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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/
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
22 | |
7 | |
6 | |
6 | |
6 |
User | Count |
---|---|
27 | |
12 | |
10 | |
9 | |
6 |