I have the following expression:
isnotblank([Replacement_VehicleReg])
Which needs to be sorted by date order asc [WEC]
There are plenty of examples in the community, I just canโt find one which suits my purpose.
Is it possible for a solution?
Kind Regards
Solved! Go to Solution.
Donโt know exactly where are you trying to sort it but Iโm assuming you are trying to do that with a dropdown. If you are trying to read values with a normal column, you can sort the order just with the SORT() expression but that doesnโt give you the option to sort with another column. The only way you can sort the order is the ORDERBY() but that works only with the Key column.
Ok Steve, its just that when the Report is run:
I would be ideal to ASC on the WEC date, but Iโm uncertain how to acheive that.
Then you can use the ORDERBY() like <<Start: ORDERBY(TableName[KeyColumn],[WEC],FALSE)>>
Perfect Aleksi, something else I have learned today.
Cheers Guys
Youโre welcome
User | Count |
---|---|
25 | |
25 | |
24 | |
21 | |
20 |