Different Periods Average in Power BI

[AkrMus]

Here is my data

Finance

I have chart that display monthly data

Like this

I need to do average for periods that are specified in another table.

Periods

So the end results should look like this

I know it should be a New Measure, but not sure how to write the DAX for that measure to do this averaging

I tried and ended with this, but it is not working

CALCULATE (
Average(Finance[Result]),
FILTER (
ALL ( Periods),
DATE ( Finance[Year], Finance[Month], 1 ) >= Periods[FromDate] 
&&  DATE ( Finance[Year], Finance[Month], 1 ) < Periods[ToDate]
)
)

but this is does not work

Anyone know how to build the measure dax to do this?

[v-chuncz-msft · Accepted solution]

@AkrMus 

You may add a calculated column first.

https://community.powerbi.com/t5/Desktop/conditional-join/m-p/340423#M152404

[Anonymous]

Hi @AkrMus ,

Please share your data with tables instead of pictures. Or if possible please share your .pbix file.

Please see this post regarding How to Get Your Question Answered Quickly:

https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

Cheers,
Rob