Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredGet Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
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
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.
Desired Outcome
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
Check out the October 2025 Power BI update to learn about new features.
| User | Count |
|---|---|
| 8 | |
| 7 | |
| 6 | |
| 5 | |
| 5 |
| User | Count |
|---|---|
| 24 | |
| 11 | |
| 9 | |
| 9 | |
| 8 |