topic Re: Extract date from Text and plot as date column in table in DAX Commands and Tips

Extract date from Text and plot as date column in table

Anonymous — Wed, 02 Nov 2022 04:02:55 GMT

I've got some data in text format with a date range attached. I've just made a date column and want to populate it with the above date range.

Please assist me with this. Attached snap.

I am using custom column to create date in power query with = #date( Year, Month, Day) to poulate entire colume with unique date.

Thanks

Saibal

Re: Extract date from Text and plot as date column in table

amitchandak — Wed, 02 Nov 2022 02:18:41 GMT

Anonymous , Is the date not there in any of the rows below, it is there in the header?

Re: Extract date from Text and plot as date column in table

Anonymous — Wed, 02 Nov 2022 02:40:11 GMT

Hi Anonymous ,

Do you want to convert [Booking ID] to date format, what is the conversion format between them.

I converted according to the previous "7 Digit Julian Date conversion", the date is not between 2022.7.1-2022.9.30.

Date.AddDays(#date(Number.RoundDown([Booking ID]/1000),1,1),Number.Mod([Booking ID],1000)-1)

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Re: Extract date from Text and plot as date column in table

Anonymous — Wed, 02 Nov 2022 04:02:36 GMT

Hi Liu Yang,

I want to exctract Date from header text "Booking Stay report Between: 1-Jul-22 to 30-Sep-22.to want to plot in two column start date and end date.

I am using custom column to create date in power query with = #date( Year, Month, Day) to poulate entire colume with unique date.

Thanks

Saibal

Re: Extract date from Text and plot as date column in table

Anonymous — Wed, 02 Nov 2022 02:55:56 GMT

Hi Amit,

Yes Date range mentioned in the header text. I want to exctract Date from header text "Booking Stay report Between: 1-Jul-22 to 30-Sep-22.to want to plot in two column start date and end date.

Thanks

Saibal