topic Re: Remove Tail End of Indexing from Cohort Periods in DAX Commands and Tips

Remove Tail End of Indexing from Cohort Periods

BICrazy — Tue, 15 Sep 2020 08:48:49 GMT

Hello Power BI Community,

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.

Re: Remove Tail End of Indexing from Cohort Periods

Fowmy — Tue, 15 Sep 2020 10:35:07 GMT

BICrazy
I have modified your measure to exclude the last three values for each row:

New Cohorts= VAR _DATE = CALCULATE(MAX(Data[date]), ALLSELECTED(Data[Date],Data[Day])) - 3 return IF( MAX(Data[Date]) <= _DATE, [Cohorts] )

________________________

If my answer was helpful, please consider Accept it as the solution to help the other members find it

Click on the Thumbs-Up icon if you like this reply 🙂

YouTube LinkedIn

Re: Remove Tail End of Indexing from Cohort Periods

BICrazy — Tue, 15 Sep 2020 10:49:45 GMT

Fowmy

Thank you again Sir!. This measure is exactly what I needed for my dashboard.