question on how to return multiple values based on a cell criteria

[ypatel]

hello.  i am fairly new to Power BI and DAX.  i have searched and cannot figure out a solution to the data i need to pull. if i have a single table (there is no lookup to another table) as below:

DoY	Advertiser	Campaign Name	IMP Goal	Potential Revenue($)
18	Car Auto	campaign 1	1897	$131.46
18	Car Auto	campaign 2	1834	$127.10
18	Visit GA	campaign 1	4142	$287.04
19	Visit GA	campaign 1	4142	$287.04
19	local grocery store	campaign 3	1834	$127.10
19	Car Auto	campaign 1	1897	$131.46
20	Car Auto	campaign 1	4142	$287.04
20	Visit GA	campaign 2	1897	$131.46
20	local grocery store	campaign 3	1834	$127.10

what i would like to do is get the last "DoY", in this case 20, return a table that shows "Advertiser", "IMP Goal" and "Potential Revenue" and display in my dashboard via a table or multi card.

the output would look something like the following:

Advertiser	IMP Goal	Potential Revenue($)
Car Auto	4142	$287.04
Visit GA	1897	$131.46
local grocery store	1834	$127.10

greatly appreciate any help here.

thank you.

[Dangar332]

HI, @ypatel 

look below image