#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.

1 year ago 4 Replies
BA
Bamidele Adeola Ajamu
1 year ago

#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

3 Likes

Replies

Alan Doe 1 year ago

Hi sorry i am new. How do you display the distinct and unique at the power query column

2 Likes
Bamidele Adeola Ajamu (1 year ago)

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

Bamidele Adeola Ajamu 1 year ago
1 Like
Alan Doe (1 year ago)

Bamidele Ajamu thank you!