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 community,
Would you please give me advice what is the best way to extract the date from this specific timespamp:
P2019Y3M11DT11H4M54S
I've tried to use MID function to exctract the parts and concatenate them by ".":
Date =
Solved! Go to Solution.
Hey,
I would do something like this:
DATE( VALUE(< something that returns the year >) ,VALUE(< something that returns the month >) ,VALUE(< something that returns the day >) )
Regards,
Tom
Thank you guys, now it works!
Hey,
I would do something like this:
DATE( VALUE(< something that returns the year >) ,VALUE(< something that returns the month >) ,VALUE(< something that returns the day >) )
Regards,
Tom
Hi Egor,
test:=date(mid("P2019Y3M11DT11H4M54S",find("P","P2019Y3M11DT11H4M54S")+1,4),mid("P2019Y3M11DT11H4M54S",find("M","P2019Y3M11DT11H4M54S")+1,2),mid("P2019Y3M11DT11H4M54S",find("Y","P2019Y3M11DT11H4M54S")+1,1))
Probably not the best way, but this works.
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
23 | |
8 | |
7 | |
6 | |
6 |
User | Count |
---|---|
28 | |
11 | |
11 | |
10 | |
6 |