Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Dear Community,
I do have a rather simple issue and I seek your help.
I have received 3 simple reports - see files attached. There are from a LinkedIn campaign and come in different tables.
The goal is, to have one report with a matrix, that tells me LinkedIn Display has 8500 Impression in week 23 respectively LinkedIn Post with 1500 Impression (in one Column only). Additionally and from the 3rd table I would like to see whether there has been an OptIn or Double OptIn.
An example report is here:
Unfortunately I wasnt able to display the impression for single items, instead PowerBi wanted me to arrange it in 2 columns.
Furthermore I couldnt connect the the opt-in counts.
Does anyone of you have a hint for me?
Hi @raymond,
According to your descriptions above, I would suggest you append the first two tables into a single table first using the Append Queries option in Query Editor.
Then you should be able to use the Merge Queries option to merge the third table and the appended table into a single table.
So finally, you will have only one table with all the data, and it should be easy to get your expected result on the report from that table.
Reference:
Append vs. Merge in Power BI and Power Query
Power BI Desktop : Merge Query Options
Regards
Hi @raymond,
Create a separated table with week (1-52) then make a relationship between that table and your other 3 tables then use that value to make your calculations to the final summary.
Regards,
MFelix
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsCovering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
118 | |
107 | |
70 | |
70 | |
43 |
User | Count |
---|---|
148 | |
104 | |
104 | |
89 | |
66 |