Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi,
As can be seen the pic below, there are subgroups of number. What i want is that for a particular incident, the subsequent row shall give the previous row value in a new coloumn, when sorted in date wise order ( for the same i have created Index col too!).
The formula which i use for fetching previous text value is as per the pic below, but is also capturing indexes of oter Number coloumn and giving way off results.
Please help the Power BI Community
Solved! Go to Solution.
hey, found the solution. Posting here so that it can help fellows in future if they face similar issue.
hey, found the solution. Posting here so that it can help fellows in future if they face similar issue.
User | Count |
---|---|
104 | |
92 | |
88 | |
78 | |
71 |
User | Count |
---|---|
113 | |
105 | |
101 | |
75 | |
64 |