Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
ello All,
I am using Power Bi desktop to create a dashbaord.
My source table has a column called Customer and has valuses as:
Micheal Lim Feb 29
....
...
I want to saparate date (Feb 29) in other new column. will call date.
So two columns will be same as below:
Column_____________ "Customer" ---- "Date"
Row_________________Micheal Lim ------ Feb 29
Please advise thanks
Solved! Go to Solution.
Try to separate them using Power Query. Go to Home --> Transform Data
Click on the table on Power Query and select the column that you want to split.
Right click on it --> Split Column --> Select Split Method (maybe delimiter will be suitable in your case)
See image below
I want to create other column called Date and moved all dates to Date column.
Current Customer column has values as below:
Micheal Lim Feb 29
....
...
Please try to do like below in query editor:
Can you give a few more examples of input rows? The exact format and number of spaces make a difference in how to split the column.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
94 | |
83 | |
67 | |
59 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |