Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
BICrazy
Helper II
Helper II

Remove Tail End of Indexing from Cohort Periods

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.


Capture.PNGCapture1.PNG

1 ACCEPTED SOLUTION
Fowmy
Super User
Super User

@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

Did I answer your question? Mark my post as a solution! and hit thumbs up


Subscribe and learn Power BI from these videos

Website LinkedIn PBI User Group

View solution in original post

2 REPLIES 2
Fowmy
Super User
Super User

@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

Did I answer your question? Mark my post as a solution! and hit thumbs up


Subscribe and learn Power BI from these videos

Website LinkedIn PBI User Group

@Fowmy 

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

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.

Top Kudoed Authors