Notifications
Clear all
Power Query
2
Posts
2
Users
0
Reactions
175
Views
Topic starter
Hi Mynda:
I ran into a problem. I noticed the order date and ship date in dd/mm/yyyy format and when I classified the columns as date, I got a month of 31. I tried to reset the region and time setting in the control panel to try to solve this issue, but no use.
Another question, after I added a column with a calculation formula, afterward wanted to change that formula, where do I go to change the formula?
Posted : 11/11/2018 6:31 pm
Hi Winnie,
To change the data format; remove the ‘Changed Type’ step. Right click the date column > Change Type > Using Locale. In this menu you can choose the date format for your locale.
Do you mean edit the formulas in Power Query? If so, click on the gear icon on the in the applied steps pane for the Added Column step.
Mynda
Posted : 12/11/2018 6:54 pm
