Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
kasun909
New Member

Groupby values from 2 non related tables

Is there a way to SUMMARIZE 2 fact tables (Fact_Revenue and Fact_Expenses etc.) using one field on one of the fact table (For Example I have the client name in the Fact_Revenue table but I do not have it in any dimension or in the other Fact_Expenses table) But I want to summarize Expenses and Revenue by Client names. There is no relationship between these 2 fact tables as well. Please help.

1 REPLY 1
Anonymous
Not applicable

If you do not have anything that references or relates to the client in the expense table, then how do you tell which expense belongs to which client?

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.