Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
I have a report that includes a measure [ConsecutiveDaysMeasure]. My objective is to create a Y/N flag to identify the first date or dates where this measure becomes greater than or equal to 4 (evaluating each student individually). Looking at an individual row, the logic would be, if the [ConsecutiveDaysMeasure] value in this row is greater than or equal to 5 AND (either there is NO prior [ConsecutiveDayMeasure] for the student OR the prior [ConsecutiveDayMeasure] for the student is NOT greater than or equal to 5), then flag "Y", else "N". On the image, the arrow represent the rows which should be flagged with a "Y".
Thanks,
John
Solved! Go to Solution.
Hi @Anonymous ,
You could download my test file and refer to it.
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
117 | |
101 | |
71 | |
61 |