Forum Discussion
Solved
How to create dimension tables correctly with this input?
Hi! I have a table on a Excel file that looks like this: I imported this table into the PowerBI Desktop and I dismantle it into two dimension tables (Year and KPI). See images below: ...
Here are some suggested modeling changes:
- Unpivot your company columns
- If you only have one column in your KPI table, you may not need it
- Not sure what the TTM rows are but you possibly could filter those out and calculate that value dynamically with a measure (or convert TTM to a date or integer value)
Pat
ppm1
Solution Sage
Solution SageHere are some suggested modeling changes:
- Unpivot your company columns
- If you only have one column in your KPI table, you may not need it
- Not sure what the TTM rows are but you possibly could filter those out and calculate that value dynamically with a measure (or convert TTM to a date or integer value)
Pat
Thank you ppm1!
With your hint to unpivot the company name tables I was able to make a way to create metrics with those values!
👍