Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi,
I am building a dashboard to track response rates to emails.
I have a number of columns in the table, and the ones i need to use are Received Time, and Subject.
The table is sorted by received time, oldest to newest.
I want to add a column that wil put a 1 against the earliest instance for each Subject.
I would like to then do the same for the second, third, fourth etc, but this would be an added bonus.
Can anyone help?
Solved! Go to Solution.
@Anonymous,
You may try using RANKX Function.
http://community.powerbi.com/t5/Desktop/How-to-get-the-latest-status-by-id/m-p/260538#M116405
@Anonymous,
You may try using RANKX Function.
http://community.powerbi.com/t5/Desktop/How-to-get-the-latest-status-by-id/m-p/260538#M116405
User | Count |
---|---|
13 | |
5 | |
2 | |
1 | |
1 |
User | Count |
---|---|
24 | |
3 | |
3 | |
2 | |
2 |