Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
So I have some data broken down by Month, Quarter, and Year. I was able to format the Month correctly as a date, but the Year is being tricky. For example: when I make it Date/Time, 2015 turns into 7/7/1905. When I switch to yyyy format, it just shows 1905. How can I get it to recognize 2015 as the correct year?
Solved! Go to Solution.
Hi There,
You should use & operator to create a date column and change the data type to date and format as yyyy to achieve the results.
Datecolumn = "1/" &"1/" &[Year]
Convert the data type to the date and let me know how it goes or need further help.
Hi There,
You should use & operator to create a date column and change the data type to date and format as yyyy to achieve the results.
Datecolumn = "1/" &"1/" &[Year]
Convert the data type to the date and let me know how it goes or need further help.
so the Year field needs to be a Number field type, not a Date field type. that's just the way it is..... or based on the title of your post you can force it to be a text field using the ribbon modeling tab.
am not entirely clear what your goal is - one thought however may be to add another field that is a true date field ....so if your periods are months have an actual date field perhaps using the 1st day of the month. I just throw that out there as a consideration but not really sure if it helps.....
I understand. My goal here is to look at month over month change as far as sales and margin go. I have that figured out by using PREVIOUSMONTH('Table'[Month]), where 'Table'[Month] is formatted as 01-MM-YYYY. Measures work great.
I also want to look at year over year change. Here i tried PREVIOUSYEAR('Table'[Month]), since I knew this has the year in it. This doesn't give me any calculations on my measures. I then figured I'd try to format the Year column as a date and use PREVIOUSYEAR on that, but it can't be formatted.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
94 | |
81 | |
66 | |
58 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |