Calculating Sum for a Column by a Set Time Period from the Past

[Anonymous]

Hello, 

  I am attempting to create a bar chart with 12 columns for each month of the year. Each column will represent 6 months of data starting from each month. (ex. January will represent a 6 month outlook until June, February will show until July, etc.) I have the data in seperate columns for each month, but they are not filtered by the time period of six months (from the beginning of that month), instead, each column for each month has data for 2+ years, not the six month periods I'm looking for. 

I used the code below, but it is still not working for me. Any suggetions would be appreciated!

Thanks!

Jan6Months = CALCULATE(SUM(Pipeline_Outlook[January 2018]),FILTER(Pipeline_Outlook, Pipeline_Outlook[Close Date] = DATEADD(Pipeline_Outlook[Close Date],6, MONTH) ))

[v-yuta-msft · Accepted solution]

@Anonymous,

Modify your measure like pattern below and check if it can meet your requirement:

Jan6Months =
VAR selected_month =
 SELECTEDVALUE ( Pipeline_Outlook[Close Date] )
RETURN
 CALCULATE (
 SUM ( Pipeline_Outlook[January 2018] ),
 FILTER (
 Pipeline_Outlook,
 MONTH ( Pipeline_Outlook[Close Date] ) >= selected_month
 && Pipeline_Outlook
 < selected_month + 6
 )
 )

Community Support Team _ Jimmy Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.