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 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)
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
24 | |
9 | |
7 | |
6 | |
6 |
User | Count |
---|---|
29 | |
11 | |
11 | |
10 | |
6 |