Last week I got some help to exclude the data that is blank and I'm using the following measure to display the percentages per Cohort ( Currently columns 1 - 14).
Cohorts = IF( [MoM % Change from Previous Index] = 0 , BLANK(), [MoM % Change from Previous Index] )
I now need help to create a DAX measure that enables the user to choose to remove the last 3 periods from the visual per row. ** Note that this is not merely chopping off columns 12, 13, and 14 from the end, but rather removing the last 3 columns of data at a ROW level. My objective is to remove the dips that are currently being displayed in the Line Chart Visual.