Fabric is Generally Available. Browse Fabric Presentations. Work
towards your Fabric certification with the Cloud Skills Challenge.
Hello-Fair warning this a novice PowerBI Question!
I know I have done this before but can't wrap my head around it.
I have 3 datasets (CSV of Users from O365, CSV of Users from Payroll, Live data source from SalesForce showing Users)
The "primary key" between all 3 data sets is the email address.
I essentailly want to compare all 3 data sets and return a table that has the following...
Column 1: email
Column 2: Exists in all 3 Data sets (if yes return TRUE if no return FALSE)
Column 3: Exists in O365 ONLY (if yes return TRUE if no return FALSE)
Column 4: Exists in SalesForce ONLY (if yes return TRUE if no return FALSE)
Column 5: Exists in Payrol ONLY (if yes return TRUE if no return FALSE)
Go to Solution.
I put together the attached .pbix with a solution that should work for you.
First we create a table with the unique emails from all lists.
DISTINCT( O365[email] ),
DISTINCT( Payroll[email] ),
DISTINCT( SalesForce[email] )
We join that back to all three lists so we can do the counts.
The some measures to count the rows in each table.
CountRowsO365 = COUNTROWS(O365)
Then start adding the columns based on those counts.
All 3 =
VAR O365CT = [CountRowsO365]
VAR PayrollCT = [CountRowsPayroll]
VAR SalesForceCT = [CountRowsSalesForce]
SalesForceCT > 0
&& O365CT > 0
&& PayrollCT > 0
, TRUE, FALSE)
Hope that helps.
View solution in original post
@jdbuchanan71 This was incredibly helpfull and worked right away for me.
Check out the November 2023 Power BI update to learn about new features.
130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.