#Splitting #column by #delimiter can be tricky.
In this example, dash was the delimiter but its occurrences in the data demands some understanding of the naming convention in the dataset.
To solve this in Power Query, there is an option of Right-most Delimiter that does justice to this type of #data #cleaning.
Also note that the data is a fictitious data.
If you find it useful, kindly #follow, #like, #share and #comment
#Tool: #Microsopt PowerBI
#LinkedIn:
#Twitter: https://lnkd.in/dJzSUWQF https://lnkd.in/dfPx-c3a
#microsoftazure #microsoftpowerbi #microsoft #googleanalytics #dataanalytics #datacamp #dataarchitect
Hi sorry i am new. How do you display the distinct and unique at the power query column
Alan Doe it is called profiling. It’s a tab in power query under view I guess. You can check and unchecked it.
Bu default it is unchecked, so you will have to check it to see it.
Would share how to add it in my next post. Thank you