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.
Howdy All, I feel like this is easy but its not working so i need some help, please! When i adjust my splicer "Billable Hours" moves but Available does not.
Available Hours = CALCULATE(SUM('1_January Available Hours'[Value])+SUM('2_February Available Hours'[Value])+SUM('3_March Available Hours'[Value])+SUM('4_April Available Hours'[Value])+SUM('5_May Available Hours'[Value])+SUM('6_June Available Hours'[Value])+SUM('7_July Available Hours'[Value])+SUM('8_August Available Hours'[Value])+SUM('9_September Available Hours'[Value])+SUM('10_October Available Hours'[Value])+SUM('11_November Available Hours'[Value])+SUM('12_December Available Hours'[Value]))
Please share more details about your measures.To help you further I need pbix file. If possible please share a sample pbix file after removing sensitive information.Thanks.
My Recent Blog -
https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-tr...
Hi @amitchandak i sent you a PM of my PBIX file so its not being shared with the masses. Let me know if i can provide more insight! thank you for the help!
Hi @zsechler ,
Wouldn't it be easier if you combined all your available hours tables into one instead importing them into your model separately?
Proud to be a Super User!
Yes it would. haha Unfortunately i am using OpenAir and the "daily" filters only allows up to 90 days....(insert crying)
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 |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
101 | |
86 | |
64 |