Average of selected dates

[prashantg364]

Below is my data set.

I want to calculate an average of Task1, Task2, and Task3 for any particular date range.

like for example 

Date range 20-03-2023 to 25-03-23

Average of Task1 = 275

Average of Task2 = 288

Average of Task3 = 399

What measure should I create to get this Average?

Date	Task1	Task2	Task3
16-03-2023	239	373	388
17-03-2023	255	288	439
18-03-2023	260	222	448
19-03-2023	9	24	50
20-03-2023	300	272	331
21-03-2023	265	242	354
22-03-2023	298	308	500
23-03-2023	307	338	434
24-03-2023	219	295	436
25-03-2023	263	276	343
26-03-2023	75	47	125
27-03-2023	299	352	633
Grand Total	2789	3037	4481

[Barthel]

Hey @prashantg364 

You can create three separate measures, each referencing a task column. For example, Task 1:

average_task_1 = AVERAGE ( 'Table'[Task1] )

 The measure automatically takes into account the date selection.