Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
taeyang
Frequent Visitor

Calculate Unit Price and Cost from values within one column in a table

I would like to calculate Unit Price / Cost of every cost element in below table (See capture PBI).

ie. Unit selling price (Row 2 / Row 1) and Unit Distribution cost (Row 4/Row 1).

 

Is there any way to do it in curret structure (See Capture Data model) ?

 

PBI

taeyang_0-1676264864952.png

 

Data Model 

Basically KPI is stacked vertically from the original data (excel) and dates are unpivoted (within BI).

Value of respective KPIs are entered in Value column.

taeyang_1-1676265257079.png

 

Desired Outcome

taeyang_2-1676265661801.png

 

 

 

0 REPLIES 0

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.