Forum Discussion
Measure with two different columns
Hi
I am trying to calculate how the energy use per ton of production. The energy use per day is in a different table than the production per day.
When I try to use the related function it get the infinite / NaN error. I am not sure how to solve this.
Energy
And production
Yes, that's kind of sample data. However, you can simplify that and not the screenshot. It's very hard for us to create the solution based on the screenshot. You can just paste some data in the reply. At last, pls let us know what the result you want to get based on the data you provided.
i just created some simple data and provide a solution. pls see the attachment and check if this is what you want.
15 Replies
Hey levialae ,
can you show the relationship?
Otherwise you should also be able to calculate that with the CALCULATE function and some modification of the filter context. What exactly do you need?
If you need any help please let me know.If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍Best regardsDenisBlog: WhatTheFact.biFollow me: twitter.com/DenSelimovicHi Denis
I have attached a screenshot of the relationship.
The relationship is between the two 'daily' columns. I have also tried the two 'DateTime' columns which I didn't change anything for me.
So what I need is:
The oil use daily divided by the daily tons produced (kiln 1 scale). This will give me how much oil did we use per ton of production.
