Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.
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.
Solved! Go to Solution.
@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 🙂
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
@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 🙂
⭕ 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.
Check out the November 2023 Power BI update to learn about new features.