CODEWITHSUNDEEP
powerbi
user6446514
user6446514

Reputation: 1

Power BI creating table/report from multiple tables

I am new to power bi and trying to create table/report that pulls data from three different tables.

I have one table "Conversion": with columns like: conversion_id, date_converted,channel, revenue and other columns and measures

Second table "Qualification": Qualification_id, date_qualified, channel, revenue and other columns and measures

Third table "Spend" : Date, channel, Spend and other columns and measures

Qualification_id is same as conversion_id but it could have different dates (dates for id that got converted and qualified many times differ) and not every id that converts qualifies.

I want to display sum(spend) , count of qualifications , count of conversion and qualification rate (qualification/conversion) grouped by date and channel in one report

enter image description here

There were no relationships detected in amongst these three tables. Please note that the date values are not unique. I am looking into creating star schema and calculated table but since I am super new to this I am struggling to create this view. Any help would be appreciated!

Upvotes: 0

Views: 853

Answers (1)

Sanchit Sood
Sanchit Sood

Reputation: 81

If I have understood correctly ,conversion_id & date_converted will match Qualification_id & Qualification_date ,if the Conversion_ID qualifies. If this is the case maybe you can create a new Column in both the tables which will be a concatenation as below and join those two columns like 

Qualification_Key = Qualification_id & "-" & Qualification_date 
Conversion_Key = Conversion_ID  & "-" & date_converted

Upvotes: 0

Related Questions