Forum Discussion

JimWorld's avatar
JimWorld
New Member
3 years ago

Creating a query based on the first 8 characters

I have a table that containes all of my sites information.   Each site is given a unique device prefix. ie caazucmp.  All of the network equipment that this site will start with these 8 characters.  How do I link this table with my device table based on the first 8 charcters in Power BI.  It is an easy task in SQL,  but I having a hard time finding a solution in Power BI.

 

Thanks for your help

Need Help

1 Reply

  • wdx223_Daniel's avatar
    wdx223_Daniel
    Community Champion
    3 years ago

    you need add a calculated column in the table

    DeviceID=LEFT(Table[ColumnName],8)

    then you can create the relationship with it.