Forum Discussion

FarmaVip's avatar
FarmaVip
Regular Visitor
3 years ago
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...
Interesting Links
Need Help
FarmaVip's avatar
FarmaVip
Regular Visitor
3 years ago

I wanted to avoid because is a pro workspace I did not wanted to used merge tables.

Creating a copy of my query and then grouping (CNPEM) then merge with my original table is the only way to do that?

  • edhans's avatar
    edhans
    Community Champion
    3 years ago

    I am not sure what a pro workspace has to do with merging queries. 

    I didn't say a conditional merge was the only way to do it, but it will work, and I think will perform better than a Table.SelectRows calcualted at every record wrapped with a List.Distinct.

     

    Either way, if you want real help, you need to provide data. I am thinking you will need a varialbe to trap the value you want to be part of the condition, but I need to see data to do code.

     

    How to get good help fast. Help us help you.

    How To Ask A Technical Question If you Really Want An Answer

    How to Get Your Question Answered Quickly - Give us a good and concise explanation
    How to provide sample data in the Power BI Forum - Provide data in a table format per the link, or share an Excel/CSV file via OneDrive, Dropbox, etc.. Provide expected output using a screenshot of Excel or other image. Do not provide a screenshot of the source data. I cannot paste an image into Power BI tables.