Forum Discussion

MattieG72MP's avatar
MattieG72MP
Advocate I
8 years ago
Solved

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...
Need Help
  • MattieG72MP's avatar
    MattieG72MP
    8 years ago

    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

  • Anonymous's avatar
    Anonymous
    8 years ago

    MattieG72MP Awesome!

MattieG72MP's avatar
MattieG72MP
Advocate I
8 years ago

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

Anonymous's avatar
Anonymous
Not applicable
8 years ago

MattieG72MP Awesome!