The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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/
User | Count |
---|---|
26 | |
12 | |
8 | |
8 | |
5 |
User | Count |
---|---|
30 | |
14 | |
12 | |
12 | |
7 |