1 of 1 people found this helpful
see the attached approach
I broke it into pieces to make it easier to follow
this is the number of days in the month
and this is the daily average
Finally this will fill in all the Null fields with the averager
to make the viz you need to fill in all the dates with Show Missing Values then apply the third formula
If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.