Extract data from measurement

[Syndicate_Admin]

Good

I do not know if anyone could help me, the question is that I need to remove the name from the cell of the column "Team Rival Player", of the measure that I have taken called "Last goal missing".

This data I have taken with the function

Last goal fouled = LASTNONBLANK(US_shots_Total[date],[Goals Missing])

And now I need to take out the team against which he scored that goal on that specific date.

Thanks and regards!

[Syndicate_Admin]

Number	Latest release date	Last goal date	Rival
German	May 28, 2023	February 18, 2023	?¿?¿??? ¿?

I have these columns, of which on the date of the last goal is a created measure.

Last goal fouled = LASTNONBLANK(US_shots_Total[date],[Goals Missing])

In the table I load I have the column "Rival Team" and the release date.

I would need to take out the opponent with respect to the column Last goal missing.

[lbendlin]

Please provide sample data (with sensitive information removed) that covers your issue or question completely, in a usable format (not as a screenshot). Leave out anything not related to the issue.
https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...
Please show the expected outcome based on the sample data you provided.

https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...