Forum Discussion
DAX
Anonymous
do you have relationships between tables?
if so, try
Imbalance = query1[residue value]+ RELATED(query2[flow value])if not, it will not be summed up or you have to define rule whats exactly cell [flow falue] from all table2 should be added
az38 I do have relationship between the tables and it's based on the dates.
But the meters in table 1 and the meters in table 2 are different (which means they have a same column but different values and flow value doesn't exist in table 1).
May be I can filter based on the meter I want to show for table 2. Though I'm not sure how to filter that out.
Anonymous
as parry2k mentioned data sample would make the solution find process more easier 🙂
The formulas i used
Imbalance = sum(query1(residue available)+sum(query2(flow value)
Residue available = query1(new flow value)+query1(shrink volume)
new flow value = if(sum(query1(flow value)>[limit],77000,query1(flow value)
limit = 77000
shrink volume = query1(new flow value)*query1(shrink %)
shrink % = 0.3581