Calculate Percentage between two data sets

[Anonymous]

Hi all, I've tried to search for this but haven't quite found what I'm looking for.

In Sheet 1 I have Elapsed Time A

In Sheet 2 I have  Elapsed Time B

I want to see a percentage of those two variables. 

Example: 45min (A) / 24hrs (B) = 3.125%

Thanks,

Kenton

[Anonymous · Accepted solution]

I may have found a solution. I used a Related function to copy the columns from table 2. Then crated a calculated column to get the percentage. 

[V-pazhen-msft]

@Anonymous 

Good, or you could have create a measure, which does not require a relationship.

Paul

[Anonymous]

Paul, I thought I tried that, but ran into an issue of measuring data between two table sources.