Forum Discussion

Frequent Visitor

5 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_ID price 1 12 1 13 1 15 2...etc. There can be several row...

General Comment

Tutorial Requests

MFelix
5 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:

Icon for Super User rank

Super User

5 years ago

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: