Forum Discussion

AnjanaPothineni's avatar
AnjanaPothineni
Frequent Visitor
3 years ago

How to extract a table name from a query string in DAX

Hi, I have a Power BI report to list all the queries that are ran as part of query auduting and I have a column that contains a query.   In order to simplify the data I need to split (extract) the ...
Need Help
Show and Tell
Tips and Tricks
grazitti_sapna's avatar
grazitti_sapna
Icon for Super User rankSuper User
3 years ago

Hi AnjanaPothineni 

You can try using this for achieving your desired output.

TableNames =
VAR StartIndex = FIND("[", 'YourTable'[Query], 1)
VAR EndIndex = FIND("]", 'YourTable'[Query], StartIndex)
RETURN
MID('YourTable'[Query], StartIndex, EndIndex - StartIndex + 1)

 

Hope this will helo you.

  • AnjanaPothineni's avatar
    AnjanaPothineni
    Frequent Visitor
    3 years ago

    Hi grazitti_sapna 

     

    Thanks for quick reply. Logic seems to work but my query has all sorts of table referecing is tere like sometimes they used schema with table name with[] and in some its a query with just table name etc. I will refine it further and apply this logic there.