I have an excel sheet that I pulled into BI. I have one column that has the year and one column that has the month. The month is not by name but by month number. I am having issues adding a combined column of "Month" and "Year" to give me an actual Date column. I have done this before but the month name was always under month and not the number. Any suggestions?
1 ACCEPTED SOLUTION
Hi @Anonymous ,
Did I answer your question? Mark my post as a solution!
Proud to be a Super User!
Hi @Anonymous ,
Did I answer your question? Mark my post as a solution!
Proud to be a Super User!
Helpful resources
Power BI Dataviz World Championships
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
Power BI Monthly Update - December 2025
Check out the December 2025 Power BI Holiday Recap!
FabCon Atlanta 2026
Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
