Hey there!

Hope you are doing fine.

I was wondering if it is possible to consider only weekdays in a normal throughput formula, or even right from the get go, in already built-in dashboards such as the follow one:

image1269361 15.3 KB

Is there already a pre-built formula for this problem?

AVG(CALC_THROUGHPUT(FIRST_OCCURRENCE[Consumption] TO LAST_OCCURRENCE[Purchase Order Release], REMAP_TIMESTAMPS(Consigned_EventLog_xlsx_Consigned_EventLog.TIMESTAMP, DAYS)))

For example in this formula.

Looking forward to hearing from you

Best,

Francisco