Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi All
My AR Table date field imported to PBI as Text.
I try to convert it to Date.
When i click on replace current , all the date erase off.
My PBI File :-
https://www.dropbox.com/s/dw3ay2or8db3100/AR_ISDN%20v003.pbix?dl=0
I have already import few raw data to PBI before no issue.
Paul Yeo
Solved! Go to Solution.
Hi @Paulyeo11
Those dates are in m/d/y format. You need to click on the column header and then Change Type -> Using Locale and choose Date, English (United States).
Regards
Phil
Proud to be a Super User!
Hi @Paulyeo11
Those dates are in m/d/y format. You need to click on the column header and then Change Type -> Using Locale and choose Date, English (United States).
Regards
Phil
Proud to be a Super User!
Hi Phil
Thank you very much for your help it work fine now.
Paul Yeo
@Paulyeo11 , my system has the US date format. SO I was able to change data type to date . You can try that in a power query or data view.
in case you have a UK format. Then better to have a new column like
new date =
var _pos = search("/",[col],,0)
return
date(right([date],4), mid([date],_pos+1,2), left([date],_pos-1))
and use that
Hi Amit
Thank you for your help.
I try at PQ , i get error :-
I try PBI , i also get error
Hope you can advise me
Paul
User | Count |
---|---|
98 | |
90 | |
82 | |
73 | |
67 |
User | Count |
---|---|
115 | |
102 | |
98 | |
71 | |
66 |