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 everyone,
I have a little trick that I'm using to concat Year & Month with a leading zero for the month and the value still be a number.
Just do Year * 100 + Month.
Example:
2023 * 100 + 3
= 202300 + 3
= 202303
works also when you have months higher than 9:
2023 * 100 + 10
= 202300 + 10
= 202310
Have fun with this!
Hi @Anonymous ,
Thanks for your nice sharing!
And there's another way to get year month number.
YearMonthNumber = VALUE(FORMAT([Date],"YYYYMM"))
If there is only the FORMAT function, it will return the text format, and you can manually modify it to a numeric type, or you can add another VALUE function to convert to a numeric type like me.
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
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 |
---|---|
109 | |
96 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
88 | |
63 |