Convert 2023-02-25T08:00:00.000Z [Text] into Date format compatible for comparing with TODAY()

[vibhuagwl]

Hi Team,

I am trying to fetch date from Bigquery and which is in text format. Now i wants to convert text into Date data type for comparing date with powerBi TODAY() function. can you please help me in this.? 

Input Date with Text Datatype- 2023-02-25T08:00:00.000Z

Output - Compatible with powerbi TODAY() function

Thanks

Vibhu

[andhiii079845 · Accepted solution]

I try it via Power Query editor. It was possible to change it directly to date/time. This happend automatically in my case:
Do you have perhaps sample datas?