Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
So I have a result coming in a column that shows the whole version, build, copyright info of the server I am querying. I would like to make seperate cards that split up the result, such as Server Version in one card, build in another, and completely drop copyright information. How do I filter the text results?
Solved! Go to Solution.
Hi @jmiridium,
Firstly, in Query Editor, split column as shown in the following screenshot.
Secondly, remove unused columns in Query Editor.
Thirdly, in Report View, create the following columns in your table.
FirstCol = LEFT(Table2[Column1.1],FIND("-",Table2[Column1.1])-1)
SecondCol = REPLACE(Table2[Column1.1],1,FIND("-",Table2[Column1.1]),"")
ThirdCol = LEFT(Table2[Column1.4],FIND(")",Table2[Column1.4]))
Regards,
Lydia Zhang
You need to either:
A) Create a calculated column(s) in query editor to grab the text you need
B) Split the column by delimeter (space?) and then combine the columns you need
C) Use DAX to create a few measures that grab the text you need
The best approach is likely C, and will be the pattern of calculating the length of the whole string and finding the location of an appropriate substring or character and then grabbing the text.
Pseudo code =
LEFT(Text,LENGTH(Text)-FIND(Substring))
So in this case this is the result unfiltered:
Microsoft SQL Server 2012 - 11.0.5058.0 (X64)
May 14 2014 18:34:29
Copyright (c) Microsoft Corporation
Enterprise Edition (64-bit) on Windows NT 6.3 <X64> (Build 9600: ) (Hypervisor)
I would like to create three new cards, one showing "Microsoft SQL Server 2012", one showing "Build: 11.0.5058.0 (X64) " and the third showing "Enterprise Edition (64-bit)"
Is this all inside one cell, or multiple rows in the column?
Inside one cell
Hi @jmiridium,
Firstly, in Query Editor, split column as shown in the following screenshot.
Secondly, remove unused columns in Query Editor.
Thirdly, in Report View, create the following columns in your table.
FirstCol = LEFT(Table2[Column1.1],FIND("-",Table2[Column1.1])-1)
SecondCol = REPLACE(Table2[Column1.1],1,FIND("-",Table2[Column1.1]),"")
ThirdCol = LEFT(Table2[Column1.4],FIND(")",Table2[Column1.4]))
Regards,
Lydia Zhang
Actually I figured out what was in the screen shot. Thank you so much!
Got the following error:
What is the special character to split by?
User | Count |
---|---|
139 | |
113 | |
103 | |
73 | |
63 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |