I have a classical Date&Time column in my database.
I would need to add a new column generated from year, month and day.
For example: 20160905 for the 5th of september 2016.
Solved! Go to Solution.
All excellent solutions!
1. Date.ToText([DateColumn], "yyyMMdd")
2. DateInt = ([Year]*10000)+([Month Nbr]*100)+[DayOfMonth])
3. =FORMAT ( [YourDateField], "YYYYMMDD" )
Join us for an in-depth look at the new Power BI features and capabilities at the free Microsoft Business Applications Launch Event.
Join our monthly meetings and learning sessions.
We are excited to announce the Power BI Super Users!
100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.