Forum Discussion

RvdHeijden's avatar
RvdHeijden
Icon for Post Prodigy rankPost Prodigy
7 years ago
Solved

Error in a Formula since last update

Hello,   I have a formula that always worked but (i think) since the last update of powerbi returns an error   It's basically a rather simple formula  Plaats = LOOKUPVALUE(Adressen[plaats];Adre...
Need Help
  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    7 years ago

    RvdHeijden

     

    My apologies

     

    Actually i wanted to write this formula.

    Lookupvalue returns error when 2 or more different values get a match

    This is just an alternate way of doing lookup

     

    Plaats =
CONCATENATEX (
    CALCULATETABLE (
        VALUES ( Adressen[plaats] ),
        FILTER ( Adressen, [Adres] = EFOS[Adres] )
    ),
    Adressen[plaats],
    ", "
)
Zubair_Muhammad's avatar
Zubair_Muhammad
Icon for Community Champion rankCommunity Champion
7 years ago

RvdHeijden

 

My apologies

 

Actually i wanted to write this formula.

Lookupvalue returns error when 2 or more different values get a match

This is just an alternate way of doing lookup

 

Plaats =
CONCATENATEX (
    CALCULATETABLE (
        VALUES ( Adressen[plaats] ),
        FILTER ( Adressen, [Adres] = EFOS[Adres] )
    ),
    Adressen[plaats],
    ", "
)
RvdHeijden's avatar
RvdHeijden
Icon for Post Prodigy rankPost Prodigy
7 years ago

Zubair_Muhammad but it still doesn't work like it should.

 

Now sometimes it returns BLANK values or a value with a ; in it for example '; Zeeland'.

I just need 1 value because all adresses are in the table 'Adressen' so its impossible to return a BLANK value or 2 values 

 

Again the formula 'Lookupvalue' worked in this rapport for the last 6 months and now all of a sudden it doesn not work anymore.

  • v-jiascu-msft's avatar
    v-jiascu-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    7 years ago

    Hi RvdHeijden,

     

    If that formula returns a value like '; Zeeland', it means that the column Adressen[Adres] has duplicates. Please refer to the snapshot below to check it easily. 

    Error-in-a-Formula-since-last-update

    If it isn't the cause, please provide a sample that can show the issue. Please mask the sensitive parts first.

     

    Best Regards,
    Dale