Forum Discussion

leudyston's avatar
leudyston
Helper I
7 years ago

Converting DAX to M

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

Need Help

2 Replies

  • Interkoubess's avatar
    Interkoubess
    Solution Sage
    7 years ago

    hi leudyston,

     

    What do you want to do exactly ?

     

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

     

    Ninter.

    • leudyston's avatar
      leudyston
      Helper I
      7 years ago

      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