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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
mcoluccia
New Member

Create new measure from two fact tables

Hello everyone,

 

I'm having issues creating a new measure with data from two fact tables.

My two fact Tables are Contract Statistics and Object Statistics.

These are both related to the dimension table Object.

On the table Contract Statistics I have the column Rental Duration, which tells me for how many days an object has been rented for a contract.

On the table Object Statistics I have the column Available Days, which tells me for how many days in a certain period an object is available for renting.

 

I have to calculate a coefficient which is Duration of rent/Available days for a given object in a given period.

Is there a standard way to perform this sort of calculation inside PowerBI?

 

Any help is appreciated...

 

Thank you all very much!

 

1 REPLY 1
v-caliao-msft
Employee
Employee

@mcoluccia,

 

Could you please provide us some sample data, and the expeted resutls for the sample data, so that we can make further analysis.

 

Regards,

Charlie Liao

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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