Forum Discussion
KPIs From Database?
Hi All
I'm trying to think of the best way to bring in KPI values from a table as I have two duplicate reports (UK and US) and each has different value's for the KPIs with each report pointing to a diffeent database of data.
Initial thoughts are to create a table with one row with the field names as the KPI name and the value is the value of the KPI but I really don't think that is great.
Does anyone else have a nice way of doing this? My KPIs at the moment are defined as metrics but they need to be data driven!
Thanks
Mattie
Hi
Basically I want to be able to load this structure and replace my current KPI Measure values definied in Power with these pairs of values from a database:
KPIID (int)
KPIName (varchar) - just for reference as name will be a measure in Power BI
KPIValue (float)
I'm going to load this table into Power BI and then do a lookup on the KPIID and set the value of the new measure to the value from the database.
I think I have answered my own question tbh but I'm surprised there isn't much information on this.
DAX LOOKUPVALUE seems like it will work well :)Thanks
Mattie
MattieG72MP Awesome!
3 Replies
MattieG72MP could you send us a screenshot of the data relationship model? Where is the data coming from?
Hi
Basically I want to be able to load this structure and replace my current KPI Measure values definied in Power with these pairs of values from a database:
KPIID (int)
KPIName (varchar) - just for reference as name will be a measure in Power BI
KPIValue (float)
I'm going to load this table into Power BI and then do a lookup on the KPIID and set the value of the new measure to the value from the database.
I think I have answered my own question tbh but I'm surprised there isn't much information on this.
DAX LOOKUPVALUE seems like it will work well :)Thanks
Mattie
MattieG72MP Awesome!