Forum Discussion
Helper ICount the Variable when it appear the first time
Hi again,
Yes, it is possible please follow these few steps (after adding index column):
1. Group by with counting all rows:2. Expand only index
3. Add a conditional column
4. remove unnecessary columns
RESULT :If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.
Helper IHi, is it possible to do the second step in Query using M language instead of in the data editor using DAX
Super UserHi again,
Yes, it is possible please follow these few steps (after adding index column):
1. Group by with counting all rows:
2. Expand only index
3. Add a conditional column
4. remove unnecessary columns
RESULT :
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.