Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Last in Power bi

hi, 

could I ask what is LAST, FIRST function in Power Bi meaning?

For example, I would like to see the PICKUP COUNTRY, DELIVERY COUNTRY, it shows me the last PICKUP COUNTRY, last DELIVERY COUNTRY. 

I dont know what does exactly means here. 

Moreover when i tried to eliminate that, there is no way for me to delete 'Last' value in matrix. 

Hope you could help

Thanks

Need Help
Show and Tell

8 Replies

  • Mariusz's avatar
    Mariusz
    Icon for Community Champion rankCommunity Champion
    7 years ago

    Hi Anonymous 

     

    To delete you can simply press x as on the picture below.

    FIRST will show the first available value within current filter context.

     

    Best Regards,
    Mariusz

    If this post helps, then please consider Accepting it as the solution.

    Please feel free to connect with me.
    Mariusz Repczynski

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      Hi, 

      Thanks for your reply. 

      I mean I just need PICKUP COUNTRY not last

       

      • Mariusz's avatar
        Mariusz
        Icon for Community Champion rankCommunity Champion
        7 years ago

        Hi Anonymous 

         

        You need to place it on Rows not in Values section.

         

         

        Best Regards,
        Mariusz

        If this post helps, then please consider Accepting it as the solution.

        Please feel free to connect with me.
        Mariusz Repczynski