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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Laocsulak
Helper I
Helper I

Data modeling for marketplace with same table with movements registered for buyers and sellers

Hello,

 

I work for a startup where we have a marketplace where we have buyers who make purchases and sellers who make sales.

 

The model of the transactions table is built in the next way: For example, if a customer makes a purchase in 3 installments, the transactions table registers 6 movements. 3 movements with the features of the installments of the buyer and 3 movements with the features of the installments of the seller.

 

What is the best way to model this, using the same transactions as the fact table for all movements or separating it into two fact tables, one for movements related to sales and one for movements related to purchases?

 

Thanks in advance!

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

@Laocsulak , Best is two tables with common dimensions like user, date etc

But you can manage with measures.

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

View solution in original post

1 REPLY 1
amitchandak
Super User
Super User

@Laocsulak , Best is two tables with common dimensions like user, date etc

But you can manage with measures.

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

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

July PBI25 Carousel

Power BI Monthly Update - July 2025

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

Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.