Dynamic Calculation Based on Date

[Anonymous]

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

[v-juanli-msft · Accepted 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

[Anonymous]

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.