Forum Discussion

Spotto's avatar
Spotto
Helper IV
4 years ago
Solved

How to ignore CONCATENATEX duplicates

hello everyone, I need some help, I'm making a measurement in a direct query table using CONCATENATEX. The measure I put it to not bring the blank fields but the problem is that when I put the resul...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi Spotto ,

    You can update the formula of measure [Nr Salesforce Reverso] as below to get it:

    Nr Salesforce Reverso =
    VAR nrsalesrev =
    CONCATENATEX (
    FILTER (
    VALUES ( 'gdp tb_Pagamento_Contrato'[SalesForce_Reverso] ),
    'gdp tb_Pagamento_Contrato'[SalesForce_Reverso] <> BLANK ()
    ),
    'gdp tb_Pagamento_Contrato'[SalesForce_Reverso],
    ", "
    )
    RETURN
    nrsalesrev

    Best Regards

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi Spotto ,

You can update the formula of measure [Nr Salesforce Reverso] as below to get it:

Nr Salesforce Reverso =
VAR nrsalesrev =
CONCATENATEX (
FILTER (
VALUES ( 'gdp tb_Pagamento_Contrato'[SalesForce_Reverso] ),
'gdp tb_Pagamento_Contrato'[SalesForce_Reverso] <> BLANK ()
),
'gdp tb_Pagamento_Contrato'[SalesForce_Reverso],
", "
)
RETURN
nrsalesrev

Best Regards

  • Spotto's avatar
    Spotto
    Helper IV
    4 years ago

    it worked, thank you very much🙂