"Reverse" Calculation

[Misca]

I'm trying to calculate the daily average gas prices per month per Country. If I'd have the daily prices it wouldn't be a problem but I only have the prices for each Monday in each Country so I have to pretend that was the price for the whole week 'till the next Monday. The problem is I believe I know how the calculation should go but I just can't type the measure...

 

[Yongle]

perhaps ...

Book1
	A	B	C
1	Day	Month
2	29/06/2020	9.50
3	30/06/2020	9.50
4	01/07/2020	9.50
5	02/07/2020	9.50
6	03/07/2020	9.50
7	04/07/2020	9.50
8	05/07/2020	9.50
9	06/07/2020	9.60
10	07/07/2020	9.60
11	08/07/2020	9.60
12	09/07/2020	9.60
13	10/07/2020	9.60
14	11/07/2020	9.60
15	12/07/2020	9.60
16	13/07/2020	9.45
17	14/07/2020	9.45
18	15/07/2020	9.45
19	16/07/2020	9.45
20	17/07/2020	9.45
21	18/07/2020	9.45
22	19/07/2020	9.45
23	20/07/2020	10.23
24	21/07/2020	10.23
25	22/07/2020	10.23
26	23/07/2020	10.23
27	24/07/2020	10.23
28	25/07/2020	10.23
29	26/07/2020	10.23
30	27/07/2020	9.40
31	28/07/2020	9.40
32	29/07/2020	9.40
33	30/07/2020	9.40
34	31/07/2020	9.40	9.66
Sheet12

Cell Formulas
Range	Formula
C34	C34	=AVERAGE($B$4:B34)

 

[Misca]

Thanks! I appreciate your input but I was looking for a DAX solution:

The data is loaded from a web site and loaded into data model using Power Query. It would be quite easy to fill in the blanks in the Power Query stage but I'd rather skip than and learn how to do the same with DAX measures.

 

[Yongle]

apologies - I picked this up as an unanswered thread and did not spot that it was asked in Power BI forum

 

[Misca]

No worries: Like I said I appreciate your input!