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.
