Forum Discussion

SAPpowerbi's avatar
SAPpowerbi
Helper II
4 years ago
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- ...
General Comment
Need Help
Show and Tell
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    4 years ago

    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.

     

Anonymous's avatar
Anonymous
Not applicable
4 years ago

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's avatar
    SAPpowerbi
    Helper II
    4 years ago

    Thank you , its working for me .