Remove incomplete months from line graph

[akhaliq7]

I have a line graph that is always having a negative slope for the latest month. How can I remove the latest month from the line graph. So say i have data from january to october the 14th. I want to remove the data in the line graph that is for the month of october. Then when I am in November the 14th I would like Novembers data to be excluded and Octobers to be included.

[Greg_Deckler · Accepted solution]

@akhaliq7 In your measure try something like this:

Measure =
  <some calculation>
  VAR __MaxDate = MAX('Date'[Date])
  VAR __EOMonth = EOMONTH(__MaxDate,0)
RETURN
  IF(__MaxDate = __EOMonth, <return something>,BLANK())

[akhaliq7]

Thanks for your help the following i tried and it worked

Sales =

VAR __TotalProfit = SUM(Sales[TotalProfit])

VAR __MaxDate = MAX('Date'[Date])

VAR __EOMonth = EOMONTH(__MaxDate,0)

RETURN

IF(__MaxDate = __EOMonth, __TotalProfit ,BLANK())