Removing data points from a chart

[Anonymous]

Hello,

I am trying to remove specific data points from a chart. On the attached, I want to show all data points for the 5 days line, all but the last period (F1 on the chart) for 30 days and all but the last three data points for 90 days. Is there a way of removing these from the chart, but keeping the rest intact? This will then update each period, so  next period, the 90 day data point for 201702 should appear.

Thanks,

Paul

[sunny_talwar]

Do you want something like the attached?

[Anonymous]

Yes, that's exactly it.

[sunny_talwar]

I have posted the application for you to see, let me know if you need the expressions I used

[Anonymous]

Apologies, I can't load the app - could you please post the expressions?

[sunny_talwar · Accepted solution]

30 days:

Sum({<F1 = {"$(='<=' & Date(AddMonths(Max(F1), -1), 'YYYYMM'))"}>}[30 days])

90 days:

Sum({<F1 = {"$(='<=' & Date(AddMonths(Max(F1), -3), 'YYYYMM'))"}>}[90 days])

[Anonymous]

Fantastic - thank you!