Forum Discussion
Issues with Change type to Date/Time
i worked out an easier solution
since i do not need the AEDT, or AEST text i removed them in advanced query editor
1. Duplicated Column (to not lose any data but not necessary)
2. Right click on column and select Replaced Values
3. Inserted AEDT in "Value to Find" and left "Replace with" as blank4. Right click on column and select Replaced Values
5. Inserted AEST in "Value to Find" and left "Replace with" as blank
6. Changed Type to Date/Time
since all values now have a date & time i can use that in my graphs with no troubles now
Hi,
Share the link from where i can download your PBI file.
Ashish_Mathur wrote:Hi,
Share the link from where i can download your PBI file.
the dates that seem to be in question are ones that include this format, so far everything else seems to work fine to convert
| Oct 8, 2018 08:42:10 AEDT |
wondering how i can convert this?
Hi Anonymous,
It seems that you want to convert the column First Discovered Column to a consistant format.
Is the data type of column First Discovered Date/time?
If it is, that is a little strange. Pleasea dummy pbix file which can reproduce the scenario, you could only share one column you want to change, so that I can have a tests on your file? You can upload it to OneDrive or Dropbox and post the link here. Do mask sensitive data before uploading.)
In addition, please share desired output.
Best Regards,
Cherry
v-piga-msft wrote:Hi Anonymous,
It seems that you want to convert the column First Discovered Column to a consistant format.
Is the data type of column First Discovered Date/time?
If it is, that is a little strange. Pleasea dummy pbix file which can reproduce the scenario, you could only share one column you want to change, so that I can have a tests on your file? You can upload it to OneDrive or Dropbox and post the link here. Do mask sensitive data before uploading.)
In addition, please share desired output.
Best Regards,
Cherry
doesnt look like its a date/time, well only the ones giving me problems dont seem to be date/time
here is the sample of the excel data i have pushed into Powerbi
https://1drv.ms/x/s!ACB0l6B7iYmP8CI
my desired output is just dd/mm/yyyy
thanks
Hi Anonymous,
By my test in Query Editor, we may could achieve your desired format in it. Please refer to the steps below.
1. Please duplicate your table.
2. Then filter the Rows by condition for the two tables.
3. Split column First Discovered by position for the two tables.
4. Remove other columns don't need.
5. Append query. Please keep the column names to be the same in the two tables.
The detail steps, please refer to the attachment.
Cherry
Best Regards,
