cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Anonymous
Not applicable

## Dividing colomns from different files

Dear,

I'm in desperate need of your help.

I have 2 data-sets which have a relation with eachother. now i would like to have a visual with a line with shows the amount "lijnen gedaan picking" divided by "Uren picking" and same for packing. And the date being the X-axis but i cannot seem to get it to work.

Your assistance is well appreciated!

1 ACCEPTED SOLUTION
Anonymous
Not applicable

Dear all,

Looks like i got it to work myself, however i really appreciate the help.

Solution was a simple meassurement which i did for all the 4 categories i did. Example:

Packing orders per uur = DIVIDE(SUM(Plakken[Orders Gedaan Packing]),SUM(Urenregistratie[Uren packing]))
3 REPLIES 3
Anonymous
Not applicable

Dear all,

Looks like i got it to work myself, however i really appreciate the help.

Solution was a simple meassurement which i did for all the 4 categories i did. Example:

Packing orders per uur = DIVIDE(SUM(Plakken[Orders Gedaan Packing]),SUM(Urenregistratie[Uren packing]))
Super User

Try

``````Picking =
SUMX (
'Plakken',
DIVIDE (
'Plakken'[lijnen gedaan picking],
RELATED ( 'Urenregistratie'[Uren picking] )
)
)
``````
Anonymous
Not applicable

hi @johnt75

First of all many thanks for your reply!

I did but i got the wrong values. I attached an example for what i'm looking for. Basically i need the following formula
Picking = Lijnen gedaan picking / (Divided by) werkuren picking

For the 5th of january the value should be 1030 / 112,50 = 9.155555....

Normally it should not be an issue to do this but given the 2 colomns are not in the same table it's causing issues.

Hope you can help! Very much appreciated

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.