Dax measure challenge

[felipesaw]

Hi friends, i need a solution in power query or dax to made this measure (column or dax)

I have a base with values ​​per month and that has the month of that database.

I have a filter by the month of the database and I need to do the calculation below.

Months left in the case of this example would be 8, which is from April to December.

and difference average is the difference between the average of the monthdatabase of April and March

cod	date	value	Monthdatabase	MEASURE
a	01/01/2023	1000	01/03/2023	=AVERAGEX(C2:C12
a	01/02/2023	1000	01/03/2023	=AVERAGEX(C2:C12
a	01/03/2023	1000	01/03/2023	=AVERAGEX(C2:C12
a	01/04/2023	1000	01/03/2023	=AVERAGEX(C2:C12
a	01/05/2023	1000	01/03/2023	=AVERAGEX(C2:C12
a	01/06/2023	1000	01/03/2023	=AVERAGEX(C2:C12
a	01/07/2023	1000	01/03/2023	=AVERAGEX(C2:C12
a	01/08/2023	1000	01/03/2023	=AVERAGEX(C2:C12
a	01/09/2023	1000	01/03/2023	=AVERAGEX(C2:C12
a	01/10/2023	1000	01/03/2023	=AVERAGEX(C2:C12
a	01/11/2023	1000	01/03/2023	=AVERAGEX(C2:C12
a	01/12/2023	1000	01/03/2023	=AVERAGEX(C2:C12
a	01/01/2023	1000	01/04/2023	=MÉDIA(C15:C17)
a	01/02/2023	1000	01/04/2023	=MÉDIA(C15:C17)
a	01/03/2023	1000	01/04/2023	=MÉDIA(C15:C17)
a	01/04/2023	2000	01/04/2023	=(AVERAGE DIFFERENCE / REMAINING MONTHS ) + AVERAGE(C15:C26)
a	01/05/2023	2000	01/04/2023	=VALUE ABOVE (APRIL VALUE)
a	01/06/2023	2000	01/04/2023	=VALUE ABOVE (APRIL VALUE)
a	01/07/2023	2000	01/04/2023	=VALUE ABOVE (APRIL VALUE)
a	01/08/2023	2000	01/04/2023	=VALUE ABOVE (APRIL VALUE)
a	01/09/2023	2000	01/04/2023	=VALUE ABOVE (APRIL VALUE)
a	01/10/2023	2000	01/04/2023	=VALUE ABOVE (APRIL VALUE)
a	01/11/2023	2000	01/04/2023	=VALUE ABOVE (APRIL VALUE)
a	01/12/2023	2000	01/04/2023	=VALUE ABOVE (APRIL VALUE)

[Anonymous]

Hi @felipesaw 

1. AVERAGEX(C2:C12 => You want to average the value from 01/01/2023 to 12/01/2023 ? So the result is 1000 ?

2. MÉDIA(C15:C17) => Count the medium between 01/01/2023 and  03/01/2023 ?  So the result is 1000 ?

3. (AVERAGE DIFFERENCE / REMAINING MONTHS ) + AVERAGE(C15:C26 => What is the difference ? Can you explain it with a data sample ?

4. VALUE ABOVE (APRIL VALUE)=> For example ?

Best Regards,
Community Support Team _ Ailsa Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.