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
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 October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
31 | |
15 | |
14 | |
13 | |
9 |