Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi, I am looking for a Dynamic function where:
If Date is filtered/displayed by Year divide Hours by 1920
If Date is filtered/displayed by Year& Month divide Hours by 160
If Date is filtered/displayed by Day divide hours by 40.
By Displayed: I would mean where date is pulled into a chart or a table and then upon drilling down form year --> month--> day the calculation changes. Thank you in advance for your help
Solved! Go to Solution.
Hi @Anonymous
To workaround this, you could try a New DAX function: ISINSCOPE.
If it doesn't help, please show me an screenshot or any other details.
Best Regards
Maggie
Hi @Anonymous
To workaround this, you could try a New DAX function: ISINSCOPE.
If it doesn't help, please show me an screenshot or any other details.
Best Regards
Maggie
Apologies for the delayed response here, I had to table this for a while, but that new function really helped! I need to test it with filters as well incase the page is filtered as a workaround. I will definitely reach out if I need additional assitance.
User | Count |
---|---|
103 | |
87 | |
77 | |
70 | |
69 |
User | Count |
---|---|
113 | |
99 | |
97 | |
72 | |
68 |