Help with average and function If

[Anonymous]

Hi mates, i need help with a problem, I want to solve this. In my work i need diferents scenarios like Half of the year, a quarter, etc. When I need to see the report in Quarter i need only a media, but if I want to see in half i need the media of sixth months, and when I selected months the information must be in real format (This is that i have), anyone can help me with this problem, please? The database is the next: 

[amitchandak]

@Anonymous , You need half-year or 6 month ?

example for QTR

QTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESQTD(('Date'[Date])), Filter(Sales, Sales[Column] = "Media") )

last 6 month

Rolling 6 = CALCULATE(sum(Sales[Sales Amount]),DATESINPERIOD('Date'[Date ],MAX('Date'[Date ]),-6,MONTH)

, Filter(Sales, Sales[Column] = "Media") )

for half year intelligence have columns like

Start Year = STARTOFYEAR('Date'[Date],"12/31")
Half = Half = if(datediff([start year],[Date],month)<6,1,2)
Half Year = [Start Year]*100 + [Half]
Half Year Rank = RANKX(all('Date'),'Date'[Half Year Start],,ASC,Dense)

and measures, add filter for media
This Half Year = CALCULATE(sum('Table'[Qty]), FILTER(ALL('Date'),'Date'[Half Year Rank]=max('Date'[Half Year Rank])))
Last Half Year = CALCULATE(sum('Table'[Qty]), FILTER(ALL('Date'),'Date'[Half Year Rank]=max('Date'[Half Year Rank])-1))

)