Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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.
User | Count |
---|---|
22 | |
11 | |
8 | |
6 | |
6 |
User | Count |
---|---|
26 | |
13 | |
11 | |
9 | |
6 |