Forum Discussion
Filter SUM Measure with Date Splicer
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.
- I am adding all the available working hours for every month
- Measure is 'Available Hours' below
- I need the outcome of available hours to be filtered down by the splicer date.
- i am using 'Billed Hours'[Date] in my splicer
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]))4 Replies
Yes it would. haha Unfortunately i am using OpenAir and the "daily" filters only allows up to 90 days....(insert crying)
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-trend/ba-p/882970Hi 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!
