Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Add columns for calculated measure in table

Hello,   In my facts table, I have a column for price and distance for every transaction. I want to put a table in my report in which I can see the average, min, max, etc, which should look as foll...
VahidDM's avatar
VahidDM
Super User
4 years ago

Hi Anonymous 

 

Try this code to add a new table:

Table =
UNION (
    ROW (
        "Metric", "Average",
        "Price", AVERAGE ( [price] ),
        "Distance", AVERAGE ( [Distance] )
    ),
    ROW (
        "Metric", "Min",
        "Price", MIN ( [price] ),
        "Distance", MIN ( [Distance] )
    ),
    ROW (
        "Metric", "Max",
        "Price", MAX ( [price] ),
        "Distance", MAX ( [Distance] )
    )
)

 

[price] = Price column 

[Distance] = Distance column

 

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

Appreciate your Kudos!!