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

ypatel — Mon, 06 Nov 2023 15:33:48 GMT

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.

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

Dangar332 — Mon, 06 Nov 2023 15:54:47 GMT

HI, ypatel

look below image

topic question on how to return multiple values based on a cell criteria in DAX Commands and Tips

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

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