Forum Discussion

boddydan's avatar
boddydan
Frequent Visitor
4 years ago
Solved

Creating a new table based on calculations performed on rows from another table

Hi,

I have a table containing a 'Transaction_ID' coumn along with a 'price' column, such as below:

Transaction_IDprice
112
113
115
2...etc. 

 

There can be several rows of this table containing the same transation IDs and I'd like to create a new table which asseses the rows and calculates the average price for each transaction, the minimum price...etc.:

Transaction_IDaverage priceminimum price
1  
2  
3  

 

I'd greatly appreciate any help with this. Many thanks.

General Comment
Need Help
Tutorial Requests
  • MFelix's avatar
    MFelix
    4 years ago

    Hi boddydan ,

     

    You have two options:

    Power Query - M Language

    • Create a new table that references the first one

    • Go to Transform Group by
    • Select the Group by ID and the average of the price:

     

     

    DAX

    • Add a new calculated table with the following code:

     

     

2 Replies

  • MFelix's avatar
    MFelix
    Icon for Super User rankSuper User
    4 years ago

    Hi boddydan ,

     

    You have two options:

    Power Query - M Language

    • Create a new table that references the first one

    • Go to Transform Group by
    • Select the Group by ID and the average of the price:

     

     

    DAX

    • Add a new calculated table with the following code:

     

     

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi boddydan ,

     

    Does the replies above solve your problem? If it has been solved, please mark the correct reply as the standard answer to help the other members find it more quickly.Thank you very much for your kind cooperation!

     

    Hope it helps,


    Community Support Team _ Caitlyn

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