Forum Discussion
Solved
Trying to Creat a Custom Column in M
Hi Guys, I want to creat a custom column in power query similar to this DAX formula, but using M: CALCULATE( DISTINCTCOUNT([CODIGO]), ALLEXCEPT(Table,[CNPEM]) Data info: CODIGO is like a p...
I think you might want to look at doing a conditional merge. I have written a blog about that here. Conditional Merge in Power Query — ehansalytics
If it performs better I will use it in my other premium Workspace, than you for the help