Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

How we can add custom column

how we can add custom column in query editor, where we can get sum of item code by Product ID. 

 

i wish to add this column in my master table where i have merged 4 -5 table by Product ID_Month&yr column which is available in my all tables and linked. 

 

i wish add column in query editor like below snap in query editor where output should be a distinct count of Item Code by product ID

https://1drv.ms/u/s!Ai3rGPgy20kLwS_QVYr_b8beh-Rc?e=ZYMzlv

Need Help

4 Replies

  • dax's avatar
    dax
    Community Support
    7 years ago

    Hi Amardeep100115,

    You could try to click "Edit Queries", then click "Groupby" and set it like below

    Best Regards,

    Zoe Zhi

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      Without grouping i wish to be have, because i have merge 4 table in that file and wish to have smae result by using custom column.

       

      Please guide

       

      • dax's avatar
        dax
        Community Support
        7 years ago

        Hi Amardeep100115,

         

        You could try below expression to create a column

        Column =
CALCULATE (
    DISTINCTCOUNT ( Table10[id] ),
    FILTER ( ALL ( Table10 ), Table10[code] = EARLIER ( Table10[code] ) )
)

        Best Regards,

        Zoe Zhi

         

        If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.