Monthly Average, over 6 months as static line on clustered column graph

[goraem]

Hi,

I have [Tbl_Sales] that has daily sales [tbl_sales.Dates] (dd/mm/yyyy) and [SalesAmount]

I want a DAX calculation to show something like - Total sales per month, Averaged over the last 6 months (full months) minus 50%.

Thanks in advance

[FreemanZ]

hi @goraem 

could elaborate your expectation on "averaged over the last 6 months (full months) minus 50%"?

[goraem]

Total Sales per month since July 2022 (july to December is 6 months whole)
Then
Average (i.e each month had 6 sales so the avg is 6) minus 50% = 3
Then
I want to plot this as a static line on a chart so compare total month sales as stacked columns

[FreemanZ]

hi @goraem 

could paste some sample data?

[goraem]

Date	Total Sales
1/07/2022	13
2/07/2022	13
3/07/2022	16
4/07/2022	17
5/07/2022	13
6/07/2022	13