Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello all,
Within QlikView, there was a function called 'FirstSortedValue', which looked something like firstsortedvalue(Quantity, Date). What this did was get the first value it could find for 'Quantity' sorted by Date. To get the reverse, the last value, it would be firstsortedvalue(Quantity, -Date).
What I'm trying to do is similar for some transactions based on the last transaction number (i.e. the highest number).
How would I do this in PowerBI, please? I'd rather not group within the data transformation, as I'll need to do this for four different dimensions.
Many thanks,
Dayna
Solved! Go to Solution.
You can use FIRSTNONBLANKVALUE() and LASTNONBLANKVALUE()
You can use FIRSTNONBLANKVALUE() and LASTNONBLANKVALUE()
User | Count |
---|---|
98 | |
90 | |
83 | |
70 | |
67 |
User | Count |
---|---|
113 | |
104 | |
101 | |
73 | |
65 |