Thanks Frederico for your answer

I don' tknow why but I thought it was clear. No problem. I'll just add all the code

SELECT M.ContaOrigem

,M.Conta

,M.Serie

,M.Utilizador

,M.Documento

,M.NumDoc

,M.Diario

,M.NumDiario

,M.DataGravacao

,M.Natureza

,M.Descricao

,M.Valor

,M.TipoConta

,M.Ano

,CASE M.Dia

WHEN '0' THEN '1'

ELSE M.Dia

END

AS DD

,CASE M.Mes

WHEN...

Got it

Thanks a lot

It's amazing the simplicity of this solution (I bet it took you 2 seconds to think and another 2 to write it).

And believe me, I've search on the web for...

• This reply was modified 2 years, 3 months ago by  pedroccamara.

Cool!!

Thank you so much guys!!!

You've been most helpful

And I've found another way:

, CASE F.Sex

WHEN 1 THEN 'Female'

WHEN 0 THEN 'Male'

ELSE 'Both'

END AS Sex

Best regards

Pedro

Very good Jeff. Such a valuable information!!

Thank you so much

Have a great weekend!

Pedro

Hello Jeff

In fact it's impossible not to love those guys.

Thanks a lot for your message

Best regards

Pedro

Hi Tom,

Thank you very much for your answer. Phil already answered this one.

Also, now i know what was my "problem" not finding those calendars: i did the search in portuguese

Thanks...

Hello Phil

This is amazing!!Exactly what I needed

It's amazing how you guys always come up with such an easy answer.

Thank you soooooo much Phil!!

Thank you very much for your answer @Phil and @Johan

I should search more before this question....which i did.....in google. Wrong place!

I promise next time i will search better

Thank you so...

I'm so sorry.

I didn't explain myself very good.

I need to see the connections between tables.

Is it possible?

Phil, I love the simple solutions and I am tempted to leave things as they are now.

Thank you so much for your clarifications, always enlightening.

Best regards

Pedro

Phil, the M query is as simple as this one :

let

Source = Table.Combine({#"Sales Comp1", #"Sales Comp2", #"Sales Comp3", #"Sales Comp4", #"Sales Comp5", #"Sales Comp6"})

in

Source

and this dataset compared with the original...

Hello Phil and thank you for your answer first of all

The data come from each database, I mean, each company has its own database. 6 or 7 lines for each...

Amazing job Phil!!

You've done all the hard work for me AND solved my problem!!!

Thank you thank you thank you!!!

Hi Jeffrey

Yes, it shows me the error : Invalid column name 'Company'