The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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
User | Count |
---|---|
15 | |
8 | |
6 | |
6 | |
5 |
User | Count |
---|---|
25 | |
13 | |
12 | |
8 | |
8 |