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.
Hello,
I have a text string that has multiple zeros along it. Since I have the data loaded in DirectQuery, I cannot do much in transformation tab and it most probably has to be through DAX, I am thinking of creating an IF conditions that scans each character and basically replaces the zeros into "" blanks..
Example:
016S0200N -> 16S2N
170W0220S -> 17W22S
Solved! Go to Solution.
Not sure how well it will work with DQ, but you can try to use the SUBSTITUTE function and replace "0" with "".
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
Not sure how well it will work with DQ, but you can try to use the SUBSTITUTE function and replace "0" with "".
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
86 | |
84 | |
66 | |
62 | |
61 |
User | Count |
---|---|
197 | |
118 | |
108 | |
78 | |
69 |