Forum Discussion

Aroc's avatar
Aroc
Frequent Visitor
8 years ago
Solved

Lookupvalue only first result

Hello   I've got a table that looks like this:   Column A Column B Column C Calculated Column 3 99 P 18 =LOOKUPVALUE([Column C];[Column A];1;[Column B];"99") 4 88 P 144 =LOOKUPV...
Need Help
  • v-sihou-msft's avatar
    v-sihou-msft
    8 years ago

    Aroc

     

    You should use EARLIER() in your filter:

     

    Column =
CALCULATE (
    FIRSTNONBLANK ( Table4[Column C], TRUE () ),
    FILTER (
        Table4,
        Table4[Column A] = 1
            && Table4[Column B] = EARLIER ( Table4[Column B] )
    )
)

     

    Regards,

v-sihou-msft's avatar
v-sihou-msft
Microsoft Employee
8 years ago

Aroc

 

You should use EARLIER() in your filter:

 

Column =
CALCULATE (
    FIRSTNONBLANK ( Table4[Column C], TRUE () ),
    FILTER (
        Table4,
        Table4[Column A] = 1
            && Table4[Column B] = EARLIER ( Table4[Column B] )
    )
)

 

Regards,

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi ,

 

In the same dax I want to add a condition to compare the column value, how to do that,

this is my formula

 

CallTypeMultipleValues = CALCULATE (
FIRSTNONBLANK ( 'ProdConsolidatedProdReport-Ganesh'[Call Type], TRUE () ),
FILTER (
'ProdConsolidatedProdReport',
'ProdConsolidatedProdReport'[Call Type] = "Callable"
&& 'InflowConsolidatedFlatFile'[EncounterNumberDuplicate] = EARLIER ( 'InflowConsolidatedFlatFile'[EncounterNumberDuplicate]
)
))
 
condtion to add s ProdConsolidatedProdReport'[Client] = 'InflowConsolidatedFlatFile'[client]
whn I add the condition it throws an error