Last in Power bi

[Anonymous]

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

[Mariusz]

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.

[Anonymous]

Hi, 

Thanks for your reply. 

I mean I just need PICKUP COUNTRY not last

[Mariusz]

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.

[Anonymous]

Hi, 

Thank you for your reply. 

I dont know why when I move it to Row. 

It disappears in the visualization!! 

[Mariusz]

Hi @Anonymous 

You can change the visual from Matrix to a Table or change the steting in Matrix visula like below.

Best Regards,
Mariusz

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

Please feel free to connect with me.

[Anonymous]

Thanks for your solution. 

I change it to Table already, the problem is it appears duplicate user id here. 

Do you have any suggestion for this problem?

[Mariusz]

Hi @Anonymous 

How would you like it to be displayed?

Best Regards,
Mariusz

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

Please feel free to connect with me.

[Anonymous]

Do you know how to adjust to available only distinct value of User ID?