Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi All,
I need some help in removing -UK from both columns Source Code and Allocation
and also everything was is after / in the Source Code
Any help please?
Thanks
Hi,
you can do this in power query, just right click the columns, select replace values type -uk in the first and leave the second blank
@DOLEARY85 I can't, wont let me if I'm querrieng the data from the database. To use Power Query I need to import the data and will take ages.
Ah okay,
for the -uk part you could create a column in report view:
For the part after the / you could use the search function to count the starting character using wildcards in the search e.g
User | Count |
---|---|
77 | |
77 | |
68 | |
67 | |
49 |
User | Count |
---|---|
108 | |
104 | |
93 | |
83 | |
64 |