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!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
i have a datamodel with workers and the workhours by week for example
Name Hours By Week
steven 40
Hanah 32
Brigit 32
Jane 40
now i want to generate a colum or a measure for their hours by month so if got their workhours by week but also by month. so if i filter op January i see their month hours if i filter februari i se their moth hours etc.
Many thanks for the Help!!
@Anonymous , refer if this can help
https://exceleratorbi.com.au/calculating-business-hours-using-dax/
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 16 | |
| 8 | |
| 4 | |
| 4 | |
| 3 |
| User | Count |
|---|---|
| 25 | |
| 13 | |
| 12 | |
| 10 | |
| 5 |