Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Multi-Conditional Lookups

Below is a simplified example of a very large data set I am working with. The goal is to consolidate data based on the tracking number.   I have two tables, one with a large amount of raw data, sho...
Tutorial Requests
Anonymous's avatar
Anonymous
Not applicable
7 years ago

Sorry about that, let me take another crack at it. Swapping out the sumx() line again:

 

calculate(max([Zone]),_table2)

I think my original mistake was using calculatetable() where a calculate() was supposed to be. 

 

Iamnvt's avatar
Iamnvt
Continued Contributor
7 years ago
Non-blank, lastdate zone = 

VAR _table2 = CALCULATETABLE(FILTER(Table1, Table1[date] = MAX(Table1[date])), Table1[Zone] <> BLANK())

return
CALCULATE(MAX('Table1'[Zone]), _table2)

look likes you entered a different measure than my measure.

There is no _table1 there

Anonymous