Converting DAX to M

[leudyston]

Hello friends

Create a calculated column without BI power, but for performance issues you are not able to configure this column without power query using M.

Column = IF(
                     CALCULATE(
                                           COUNTX(
                                                            FILTER(VinculoAtivo
                                                                          ;VinculoAtivo[codcontatopf] = 
                                  MAX(TDClientePessoaFisica[CodClientePessoaFisica]))
                                                            ;VinculoAtivo[codcontatopf])
                                           )>0
                    ;1
                    ;0)

Best regards

Leudyston

[Interkoubess]

hi @leudyston,

What do you want to do exactly ?

With little sample data and expected results I can try to help.

Ninter.

[leudyston]

Hi @Interkoubess, I have a client dimension (TDClientePessoaFisica), and a table that I bring from another data source, where this table (VinculoAtivo) is bringing which clients are with active link, these two tables are related by the code of the client. In the column calculated in DAX, I am filtering all clients of the client dimension that have active link and determining 1 for them and 0 for those that do not have active lin

I want to do the same thing I did in DAX, now in M ​​to be able to create this column in Power QUERY.

Can you understand me?

Best Regards

Leudyston