Get certified for free when you join Fabric Data Days 2026 and dive into Fabric, Power BI, SQL, AI, and other essential data skills.
Join nowTry your skills in the Power BI Dataviz World Championship! Round one ends June 26. Join now
Hi Team,
I have Date column as text, so when i change it to Date format and later I try to add new column in Power query editor, I see no add column option but when i remove the change type step i get add column option.
How do i add new column after changing datatype.
Source : Power BI Imports - SSAS Cubes
you will find it here
As said after changing the datatype. I see no option to new columns as shown below
here you go
what do you want to add
| User | Count |
|---|---|
| 22 | |
| 21 | |
| 20 | |
| 20 | |
| 11 |
| User | Count |
|---|---|
| 62 | |
| 55 | |
| 46 | |
| 45 | |
| 34 |