cancel
Showing results for
Did you mean:
Regular Visitor

## how to write this formula in PowerBI ?

I have written a formula in Tableau  which is this

([Per Unit Price (\$)]-[Per Unit Cost (\$)])*[Units Sold]

now i want to write in powerbi

can someone show me how to write it in PowerBI

1 ACCEPTED SOLUTION

Accepted Solutions
Member

## Re: how to write this formula in PowerBI ?

Hi,

It depends if you want to use calculated column or measure. For calculated column just write: test_column = (unit price - unit cost)*Units sold. In case of measure: test_meamure = (sum(unit price) - sum(unit cost))*sum(unit sold).

Member

## Re: how to write this formula in PowerBI ?

Hi,

It depends if you want to use calculated column or measure. For calculated column just write: test_column = (unit price - unit cost)*Units sold. In case of measure: test_meamure = (sum(unit price) - sum(unit cost))*sum(unit sold).

Announcements

#### Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

#### Super User Challenge: Can You Solve These?

We're celebrating the start of the New Super User season with our first ever Super User 'Can You Solve These?' challenge.

#### January 2020 Community Highlights

Make sure you didn't miss any of the things that happened in the community in January!

Top Solution Authors
Top Kudoed Authors