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

 

Try this alternative

 

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

    Zubair_Muhammad

    Thank you for responding but that new formula doesnt return the correct value because sometimes it returns 1, 2 or even 3 values

    I believe it should be a lookupvalue because i need the value from another table to be placed in another table

    • 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.