Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello, I would like to add 2 specific dates in separate columns in my Power query.
I would like the dates as follows:
1. Start date 20230101 (YYYYMMDD)
2. End date 20300101 (YYYYMMDD)
I have read a lot of the similar questions on here but just cant find an exact solution.
thank you 🙂
Solved! Go to Solution.
Hi @GSCPM ,
Maybe the following helps:
Before:
After:
I did this:
Is it this you were looking for? Otherwise, feel free to explain it more or provide sample data 🙂
/Tom
https://www.tackytech.blog/
https://www.instagram.com/tackytechtom/
Did I answer your question❓➡️ Please, mark my post as a solution ✔️ |
Also happily accepting Kudos 🙂 |
Feel free to connect with me on LinkedIn! |
#proudtobeasuperuser |
Hi @GSCPM ,
Maybe the following helps:
Before:
After:
I did this:
Is it this you were looking for? Otherwise, feel free to explain it more or provide sample data 🙂
/Tom
https://www.tackytech.blog/
https://www.instagram.com/tackytechtom/
Did I answer your question❓➡️ Please, mark my post as a solution ✔️ |
Also happily accepting Kudos 🙂 |
Feel free to connect with me on LinkedIn! |
#proudtobeasuperuser |
Thank you so much, so easy when you know how 😉
Much appreciated