Forum Discussion
Solved
Need Bottom 3 rows data
Hello Team , I need small help to write dax or any soltion for below issue. - I have requirment were i need to find bottom3 rows . below is Dummy Example for your referance - Source data- ...
Hi SAPpowerbi ,
Whether your Value filed is a measure or a calculated column, you need to be clear about this. There is still a difference between the two.
Can you enter the Power Query Editor? If you can, you can create a index in it.
Then use TOP N to filter.
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
SAPpowerbi You need to try TOPN solution from filter pane. I have attached SS for your reference kindly follow and apply the same filter in TOPN of category name so you'll get the required output as per your need.