Dax measure challenge

felipesaw — Thu, 29 Dec 2022 16:25:58 GMT

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)

Re: Dax measure challenge

Anonymous — Fri, 30 Dec 2022 09:27:05 GMT

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.

topic Re: Dax measure challenge in DAX Commands and Tips

Dax measure challenge

Re: Dax measure challenge