Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I need help to filter rows.
It needs to be made in edit query, NOT in DAX:
i need to filter a row if "gbl" is included in a string
like the SQL LIKE %gbl%
example if the row is like
x-scope/house-bill-of-lading-copy-pdf-custom;gon_aaagblse; customFormOID=77d3a26a-ce9c-4b95-9780-b0a36fb4059a
need to be keepd and filter since inclute gbl -> aagblse
all post I found was in DAX
You can create a new custom column with Text.Contains([Column], "gbl") and filter this column in the next step, so it only shows TRUE values.
https://docs.microsoft.com/de-de/powerquery-m/text-contains
Just thought about, you can do it even easier in Edit Query. Click on the Filter Arrow next to the column name, select Text Filters -> Contains.
this is not in edit query, I'm wrong?
User | Count |
---|---|
101 | |
90 | |
79 | |
70 | |
70 |
User | Count |
---|---|
112 | |
96 | |
96 | |
75 | |
72 |