Forum Discussion
How to Calculate Daily Average with a Separate Working Days Table?
Hi, I've tried a few measures myslef and from this forum to calculate daily average with specific working days per month. They all failed. I have this separate working days table: Date...
Hello Anonymous
These should get you there.
Revenue Portion = SUMX ( Volume, DIVIDE ( Volume[Revenue] , RELATED ( Days[Working Days] ) ) )Volume Portion = SUMX ( Volume, DIVIDE ( Volume[Volume RPT] , RELATED ( Days[Working Days] ) ) )I have attached my sample file for you to take a look at.
If this solves your issues please mark it as the solution. Kudos 👍 are nice too.
jdbuchanan71
Super User
Super UserHello Anonymous
These should get you there.
Revenue Portion = SUMX ( Volume, DIVIDE ( Volume[Revenue] , RELATED ( Days[Working Days] ) ) )Volume Portion = SUMX ( Volume, DIVIDE ( Volume[Volume RPT] , RELATED ( Days[Working Days] ) ) )
I have attached my sample file for you to take a look at.
If this solves your issues please mark it as the solution. Kudos 👍 are nice too.