cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Ilyes Regular Visitor
Regular Visitor

Dividing values from 2 different tables

I have this data from 2 different table(no relation), I want to divide Material stop counter/runtime for each different size.
for example for line 1 : 10/26665 and store the result in a column
NB: for each change of month or line of course the values will change for both tables

3 REPLIES 3
Highlighted
faizannaeem Regular Visitor
Regular Visitor

Re: Dividing values from 2 different tables

Hi @Ilyes ,

 

I believe you can use relatedtable function and divide the values using that.

 

Let me know if it helps.

 

Thanks!

 

 

Ilyes Regular Visitor
Regular Visitor

Re: Dividing values from 2 different tables

Thank for your reply, but it doesn't help because the tables are not related

Community Support Team
Community Support Team

Re: Dividing values from 2 different tables

Hi @Ilyes ,

 

Kindly share your sample data and excepted result to me if you don't have any Confidential Information. Please upload your files to One Drive and share the link here.

 

Community Support Team _ Frank
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Power BI Helps Homeless and Trouble Youth

Power BI Helps Homeless and Trouble Youth

We spoke with Power BI Super User, Greg Deckler, about his charity work

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Users Online
Currently online: 43 members 1,160 guests
Please welcome our newest community members: