Forum Discussion
Measure with two different columns
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.
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?
Hi 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.
