The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
Hi
Is there any dynamic measure that can divide values depending on which date hierachy is selected?
I have workinghours in one column and instead of workinghours i want to show this value in Full-time equivalent (FTE). So for instance if I have 500 hours on daily basis. I divide this number with 7,6 which gives mee the FTE for our business per day. 500/7,6 = 65,7
But if I change the date hierachy to weeks instead of days I want this measure to be dynamic. So for a normal workweek this should be 500*5 (workdays) /(7,6*5) which should give me the same value.
Is there any way to make this "divide" value (7,6) dynamic depending on what is filtered (day, week, mont, year)?
(I have a seperat date calender which has a column for if the date is a workingday or not)
Thanks 🙂
@d_gullik , you can use isinscope to switch measure and networkdays two get working days
IsInScope - Switch Measure at different levels: https://youtu.be/kh0gezKICEM
https://www.kasperonbi.com/use-isinscope-to-get-the-right-hierarchy-level-in-dax/
Power BI - Business day with and without using DAX Function NETWORKDAYS: https://www.youtube.com/watch?v=Qs03ZZXXE_c