Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
There is a data entry error in a date field that I'm trying to replace using the "Replace Values" in the query editor. I want to replace "5/8/2016" with "5/7/2016". however, when try to do this using the "Replace Value" function, it doesn't change. Is their a formatting issue that needs to be done first?
Solved! Go to Solution.
There should be no issue if the column is of type date. Notice that dates don't come with surrounding double quotes.
This is how it looks like, including the generated code (note" I'm configured on culture "en-US"):
Hi @Rsanjuan,
Could you please mark the proper answer if it's convenient for you? That will be a help to others.
Best Regards!
Dale
There should be no issue if the column is of type date. Notice that dates don't come with surrounding double quotes.
This is how it looks like, including the generated code (note" I'm configured on culture "en-US"):
User | Count |
---|---|
139 | |
113 | |
103 | |
73 | |
63 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |