Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
hi @leudyston,
What do you want to do exactly ?
With little sample data and expected results I can try to help.
Ninter.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
97 | |
85 | |
70 | |
61 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |