Forum Discussion
Help creating a column that determines whether or not a row is displayed after counter reset
Thanks for the reply from lbendlin.
Hi PomJack,
As lbendlin said, we can create a measure and here are the steps to do so:
1. Create a measure:
Display = VAR _date=CALCULATE(MAX('Table'[Time Stamp]),FILTER(ALL('Table'),'Table'[Error Count]=1)) RETURN IF(MAX('Table'[Time Stamp])>=_date,"y","n")2. Filter the data with the measure value of y:
3. Result:
Best Regards,
ZhuIf there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Yes, that is one way of framing the problem.
Super UserI added the sample code.
The table in this question is already in table view in Power BI. The Error Count column is a new calculated column in the table view. Is there a way to do the same thing as above, but in table view instead of power query? I should have included these details in the original post.
- lbendlin
The logic is the same. Create a measure to find the newest Date that has an error count of 1, then filter to show that data and any newer dates.
Thanks for the reply from lbendlin.
Hi PomJack,
As lbendlin said, we can create a measure and here are the steps to do so:
1. Create a measure:
Display = VAR _date=CALCULATE(MAX('Table'[Time Stamp]),FILTER(ALL('Table'),'Table'[Error Count]=1)) RETURN IF(MAX('Table'[Time Stamp])>=_date,"y","n")2. Filter the data with the measure value of y:
3. Result:
Best Regards,
ZhuIf there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.