"The Following Error Ocurred" but its empty

[Anonymous]

Hello !

I have an budget report that i use Unique IDs to match the costs file and the budget file

To create the ID i simple concatenate colunms like = A & B & C

It was working just fine, until i find some errors on my data and had to rebuild it from almost the start.

Now, everytime i try to concatenate more then 4 colunm, it gives this empty error like:

Heres the formula:

Auxiliar = 'Base de Dados'[Cursed Account]&'Base de Dados'[Centro custo]&'Base de Dados'[N Mês]&'Base de Dados'[Data de lançamento].[Ano]

I can´t upload my PBIX, since i work with an intranet connection, but i can send it via e-mail, if its necessary (Not sure if the data will still the same, since i use data flows and SAP BW)

Can you guys help me please ?

[Pragati11]

Hi @Anonymous ,

As the DAX is in some other language, I am guessing that something is going wrong in the last Column referenced in the DAX expression. It looks like the last column is a DATE type column and you are trying to concatenate just the DAY/MONTH/YEAR part of it.

Rather than accessing TABLE1[DateCol].[MONTH], try using MONTH(TABLE1[DateCol]). Basically you are using MONTH DAX function here.

If this also gives error, try using CONCATENATE function to concatenate your columns.

Thanks,

Pragati

[Anonymous]

Hello @Pragati11 , thanks for the reply!

Sorry, i forgot to translate my code, but i did tried to change it to the MONTH(), but it didn´t worked:

[Pragati11]

Hi @Anonymous ,

Can you try using CONCATENATE function and check if the error still persists?

Thanks,

Pragati

[Anonymous]

I tried it, it works just fine, even with year and month, but if i try to merge other colunms, i got the same error:

this is year and month, both of them work togheter just fine, but since i need Account , cost center, month and year, it stilss gives me the error.

Cost center and account:

No error, but when i try to merge both of the concatenates (even on separeted dax colunms, the error still persists)

[Pragati11 · Accepted solution]

Hi @Anonymous ,

Is there any description for the error?

What is the data-type for both of the above created concatenated columns? I would suppose they shold have TEXT data-type.

Can you attach sample data as a file, so that I can try at my end?

Thanks,

Pragati

[Anonymous]

@Pragati11 it was indeed not as 'text', as it should be, so i basically made 2 concatenate colunms ( 2 for each one i needed), and create a third one, concatenating A and B, as text, and it worked !

Thanks for the support !