cancel
Showing results for
Did you mean:
Member

## 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

I have 2 different tables (Adressen and EFOS) that have a calculated column in it to combi certain fields
for example
Adres = EFOS[postcode]&", "& EFOS[huisnr]&", "&EFOS[toevoeging]&", "&EFOS[kamer]

Which basically makes an unique field out of the adres and the same formula is in the table 'Adressen' and in 'EFOS' and with the lookup formula it adds the City in a third table but now the error says
"There was given a table with multiple values there where a single value was expected" roughly translated.

Any ideas on how to correct that ?
There are BLANK values in the colum Adressen[Plaats]  so maybe that is the issue now ? (even though it never was before)
1 ACCEPTED SOLUTION

Accepted Solutions
Super User

## Re: Error in a Formula since last update

@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 (
),
", "
)
```
5 REPLIES 5
Highlighted
Super User

## Re: Error in a Formula since last update

@RvdHeijden

Try this alternative

```Plaats =
CONCATENATEX (
", "
)
```
Member

## Re: Error in a Formula since last update

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

Super User

## Re: Error in a Formula since last update

@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 (
),
", "
)
```
Member

## Re: Error in a Formula since last update

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

Super Contributor

## Re: Error in a Formula since last update

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.

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

Best Regards,
Dale

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Announcements

#### Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

#### Community News & Announcements

Get your latest community news and announcements.

#### Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

#### Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Top Kudoed Authors
Users Online
Currently online: 303 members 3,081 guests
Recent signins: