Show only data from the latest date

[ljkeefe]

Hello -
sorry for the table below but I think my organization blocked XL2BB,it will no longer load to my Excel. Anyway, I'm trying to chart only the contents of Tank 1 and Tank 2 by latest date. I've chosen a column chart and added a measure with the following formula to provide me with the numbers by the latest date:
Measure = VAR LatestDate = Calculate (MAX(Table2[Date], ALL(Table2)), IF(MIN('Table2'[Date])=LatestDate, 1,0))

The goal is to graph how much of the 8,000 gallon capacity each tank has at the latest date.
When I got the formula to do something (not what I wanted) it showed me a total of the two tanks and would sum all the amounts entered in Tank 1 and Tank 2. I've messed with the formula so much now that it's giving me an error.
Your help is appreciated.

Date	Truck	Operator	CCB	Sand	Sno Melt	Salt	CCB Replenishment	CCB Available	Tank 1	Tank 2
								16,000	8000​	8000​
1/1/20			500					15,500	8000​	7,500​
1/15/20			2000					13,500	8000​	5,500​
1/20/20			1000				2000	14,500	8000​	6,500​
								14,500	0​	0​
								14,500	0​	0​
								14,500	0​	0​
								14,500	0​	0​
								14,500	0​	0​
								14,500	0​	0​
								14,500	0​	0​
								14,500	0​	0​
								14,500	0​	0​
								14,500	0​	0​
								14,500	0​	0​
								14,500	0​	0​
								14,500	0​	0​
								14,500	0​	0​

 

[Toadstool]

I may have misunderstood the request but is this what you wanted?

Book1
	A	B	C	D	E	F	G	H	I	J	K	L	M	N
1	Date	Truck	Operator	CCB	Sand	Sno Melt	Salt	CCB Replenishment	CCB Available	Tank 1	Tank 2		Tank 1	Tank 2
2									16,000	8000	8000		8000	6500
3	1/1/2020			500					15,500	8000	7500
4	1/15/2020			2000					13,500	8000	5500
5	1/20/2020			1000				2000	14,500	8000	6500
6									14,500	0	0
7									14,500	0	0
8									14,500	0	0
9									14,500	0	0
10									14,500	0	0
11									14,500	0	0
12									14,500	0	0
13									14,500	0	0
14									14,500	0	0
15									14,500	0	0
16									14,500	0	0
17									14,500	0	0
18									14,500	0	0
19									14,500	0	0
Sheet1

Cell Formulas
Range	Formula
M2:N2	M2	=INDEX(J2:J19,MATCH(MAX($A2:$A19),$A2:$A19,0))

 

[ljkeefe]

I want the graph to reflect the new amounts in the tanks as a new entry is made. Columns J, K, D and I all have formulas in them already. I'd like the graph to be in PowerBI, unless I can do that in Excel.