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

Frequent Visitor

## Discovering the current liquid value of the tank based dates of liquid input and output

Hello people,

Let's suppose that I want to monitor the liquid level of 5 tanks - A, B, C, D and E, which have their capacities

We have a table (Liquid Input) for the amount of liquid injected into the tanks with the start and end date/time.

Then we have a table (Liquid Output) for the removal of liquid from each tank with the start and end date/time.

I would like a view of the current amount of liquid in each tank, like this:

Thus, I would like a visualization that shows the current amount of liquid in each tank to take into account the dates/time of liquid withdrawal, for example:
On the 20th we have 300L of liquid in Tank A. In the afternoon of the 21st, another 500L of liquid was placed in the tank. We have 800L so far. Arriving at night, they removed 300L, making the current volume of 500L.
Until the 23rd there was no liquid entry, but there was a 300L removal, making the new current volume of 200L.

And let's assume that the input and output tables are constantly updated.

Best Regards.

1 ACCEPTED SOLUTION
Community Support

Hi @Mentzer ,

According to your description, here are my steps you can follow as a solution.

(1) My test data is the same as yours.

(2) We can create a measure.

``````Capacity =
var _input=CALCULATE(SUM('Liquid Input'[Injected Liquid]),FILTER(ALL('Liquid Input'),'Liquid Input'[Tank]=MAX('Liquid Input'[Tank])))
var _output=CALCULATE(SUM('Liquid Output'[Removed Liquid]),FILTER(ALL('Liquid Output'),'Liquid Output'[Tank]=MAX('Liquid Input'[Tank])))
return _input-_output``````

(3) Then the result is as follows.

Best Regards,

Neeko Tang

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

2 REPLIES 2
Community Support

Hi @Mentzer ,

According to your description, here are my steps you can follow as a solution.

(1) My test data is the same as yours.

(2) We can create a measure.

``````Capacity =
var _input=CALCULATE(SUM('Liquid Input'[Injected Liquid]),FILTER(ALL('Liquid Input'),'Liquid Input'[Tank]=MAX('Liquid Input'[Tank])))
var _output=CALCULATE(SUM('Liquid Output'[Removed Liquid]),FILTER(ALL('Liquid Output'),'Liquid Output'[Tank]=MAX('Liquid Input'[Tank])))
return _input-_output``````

(3) Then the result is as follows.

Best Regards,

Neeko Tang

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

Responsive Resident

Hi,

this can be done by union both the table and based on "conclution date", input as (+) value and output as (-) value , tank name.  if you still feel it difficult, share these tables so that I can copy those values.

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.

#### Power BI Monthly Update - August 2024

Check out the August 2024 Power BI update to learn about new features.

#### Fabric Community Update - August 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors