Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi everyone, please find below snapshot of inconsistent dates coming from an api. Is there anyone here know how can I clean the inconsistencies of it efficiently? Thanks in advance 🙂
Solved! Go to Solution.
@ronaldbalza2023 , Check if a new column in power query
= Date.FromText([Date Won loss])
can work
Or you can use Text.Middle if you have get a character and based to that you can choose different formatting option
@ronaldbalza2023 , Check if a new column in power query
= Date.FromText([Date Won loss])
can work
Or you can use Text.Middle if you have get a character and based to that you can choose different formatting option
User | Count |
---|---|
98 | |
90 | |
82 | |
73 | |
67 |
User | Count |
---|---|
115 | |
102 | |
98 | |
71 | |
67 |