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.
Hi All,
See the below pic. How do I sort this issue and make it from Jan 2015 to Dec 2015, followed by....Jan 2016..
Kindly help.
Thanks
Krishna
Solved! Go to Solution.
You'll need to change the measure such that you are recording a date. I'd recommend using:
YearMonth = DATE([Year], [Month], 1)
Under Modelling, set the DataType as "Date" and Format to be "March 2001(MMMM yyyy)"
EDIT: The measure above assumes your Month and Year are columns. If not, take your Date field and use YEAR([DateField]) and MONTH([DateField])
It looks like your data is of type "Text" instead of "Date", is that correct?
Hi Ross,
I changed it to date but when I try to change it, it shows me this error ?
How do I rectify this ?
Thanks
Krishna
You'll need to change the measure such that you are recording a date. I'd recommend using:
YearMonth = DATE([Year], [Month], 1)
Under Modelling, set the DataType as "Date" and Format to be "March 2001(MMMM yyyy)"
EDIT: The measure above assumes your Month and Year are columns. If not, take your Date field and use YEAR([DateField]) and MONTH([DateField])
Thanks a ton ! @Anonymous
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 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
94 | |
84 | |
67 |