The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event: Join us in Stockholm, September 24-27, 2024.
Save €200 with code MSCUST on top of early bird pricing!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
Hello,
I'm having trouble linking together two tables and getting the results I'm after. Relatively new to this paradigm so any help at all would be so helpful.
1. A leads table
2. A log of spend by cost category
All I need to be able to do is be able to see the return on investment by Cost Category over time and ideally, the cost per lead for each cost category in a given month.
I'm happy writing the measures to work out ROI and CPL once the tables are linked, but I can't work out the correct way to link them.
I'm probably being stupid but hopefully the solution is relatively simple. Examples of each table are below.
Leads
Created Date | Lead id | Cost Category | Revenue |
01/01/2023 | iklvnsdklnfdls | Paid Search | 10,000 |
04/02/2023 | jnfurbeybvas | Paid Social | 5,000 |
Cost Category
Date | Cost Category | Cost |
12/01/2023 | Paid Search | 1354 |
28/02/2024 | Paid Social | 2100 |
You need to add a Dates table to your data model, and describe the reporting granularity (you said monthly?)
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 August 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
79 | |
71 | |
48 | |
41 |
User | Count |
---|---|
138 | |
108 | |
71 | |
64 | |
58 |