Quotation table date field issue

[Paulyeo11]

Hi All

I have a QUOTATION table.

i have problem on how to convert the doc date field to date 

Hope some one can help me.

My issue is when i use location to change , it return all null

https://www.dropbox.com/s/6rwm6jj9iiliajs/QUOT_PW.csv?dl=0

Paul

[V-pazhen-msft · Accepted solution]

@Paulyeo11 
Thank you, I see the sample now. The original text data included date and time, so you can only change the data type to date/time, if you only want the date, you could split afterwards.

Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.

[Paulyeo11]

Hi Paul

Thank you it work fine now.

Paul

[V-pazhen-msft]

@Paulyeo11 

Still, I don't see any thing like Doc Date column in the sample. 

What about create a sample with the doc date column, remember mention the original data type of the column.

Doc date

xxx

xxx

xxxx

...

Regards

[Paulyeo11]

Hi Pazhen

Enclosed below my CSV file , and you help me import to PBI can ? hope that you can make the date file in date format.

https://www.dropbox.com/s/6rwm6jj9iiliajs/QUOT_PW.csv?dl=0

Above link is my CSV file .

Paul

[amitchandak]

@Paulyeo11 , we will not be able to open data transformation as we do not have source access.

Please share sample data.

[Paulyeo11]

Hi Amit

https://www.dropbox.com/s/ma8brqs60wy1kh6/INVC_PM.csv?dl=0

Encloed link for my sample data in CSV .

Paul

[Anonymous]

Your screen does not show doc date field

Your screen does not show what you do in Change Type

Your screen does not show the formula you use

In order to help i think we need more info