Forum Discussion
Helper IIHelp with Concatenate Text in Power BI
hi amaral_diego ,
then try like:
measure =
MAXX(RELATEDTABLE(d_Sócios),d_Sócios[Professional Name])
&
MAX(f_PRINCIPAL[GESTOR])
Thanks for your assistance, but I've found another way more familiar to do.
Super Userhi amaral_diego
how are they related?
Supposing d_Sócios is on the one side, try like:
measure =
MAX(d_Sócios[Professional Name])
&
MAXX(RELATEDTABLE(f_PRINCIPAL), f_PRINCIPAL[GESTOR])
Helper III've tried with your code, without success,
they are related many to one
many from GESTOR Column from the table f_PRINCIPAL
one from Sigla Column from the table d_Sócios
I now how to do it in power apps
is something like that
Text = "Head: " & LookUp(d_Sócios, ID = ThisItem.ID, [Nome Profissional]) & " (" & LookUp(f_PRINCIPAL, ID = ThisItem.ID, [GESTOR]) & ")"
I need to know, if is possible to do something similiar on Power BI
- FreemanZ
hi amaral_diego ,
then try like:
measure =
MAXX(RELATEDTABLE(d_Sócios),d_Sócios[Professional Name])
&
MAX(f_PRINCIPAL[GESTOR])
- amaral_diego
Thanks for your assistance, but I've found another way more familiar to do.