Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hi
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
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.
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
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
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
25 | |
10 | |
7 | |
6 | |
6 |
User | Count |
---|---|
30 | |
11 | |
11 | |
10 | |
6 |