The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event! Join us in Stockholm, Sweden from September 24-27, 2024.
2-for-1 sale on June 20 only!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
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.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
57 | |
32 | |
20 | |
17 | |
15 |
User | Count |
---|---|
49 | |
33 | |
30 | |
23 | |
20 |