March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early bird discount ends December 31.
Register NowBe one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now
Hi all
I have a monthly data source which has date columns showing:
I am trying to create a new date column that gives 1st of the month for a standard UK date format e.g. top row would be 01/04/2017.
I have calculated the year from the fiscal year (labelled year in the table) and the month number from month column:
Now all it seems I need to do is add a "01/" & MONTHUM &"/" & Year but its now a string. How do I get a proper date?
Manyy thanks
Solved! Go to Solution.
My advice is to not create a string, but an actual date column and than add your favorite date format. to create the date (computed) colum: DATE([Year], [MONTHNUM],1)
I Have managed to fix it now using Bing Chat which gave me:
DATE([Year], [Month Number], 1)
Works just fine!
My advice is to not create a string, but an actual date column and than add your favorite date format. to create the date (computed) colum: DATE([Year], [MONTHNUM],1)
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.
Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.
User | Count |
---|---|
23 | |
15 | |
12 | |
9 | |
8 |
User | Count |
---|---|
41 | |
32 | |
29 | |
13 | |
13 |