Forum Discussion

Regular Visitor

7 years ago

Solved

Lookup based on 2 criteria

Hello I have a problem that I am trying to solve and cannot get it sorted currently I have a table of data from Azure Devops which includes history for every item in the system. This data ha...

Need Help

Anonymous

7 years ago

try this measure:

Measure = 
IF ( HASONEVALUE(Table1[Info]),
CALCULATE(
    VALUES( Table1[Info]),
    CALCULATETABLE(
        Table1,
        ALLSELECTED(Table1[Date])
    )
)
)