Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredJoin us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM. Register now.
I have a one column with dates from year 2021 to year 2024. From this, how can i make seprate columns for each year.
Hi,
Create a new Calculated column by this DAX Code:
YearColumn = YEAR('YourTable'[DateColumn])
Or by:
YearColumn = FORMAT('YourTable'[DateColumn],"Yyyy")
pls provide some sample data and expected output
Proud to be a Super User!
Hi @ealiisl
What does the data look like?
If something like this you can tell the data to pivot.
If you are happy with this answer please mark as a solution for others to find !
Kudos are always appreciated! Check out our free Power BI video courses.
Hello Sam:
unfortunately not like this. i dont want to count the occurances. I want each year in seprate column because every cell has different date.
Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!
Check out the October 2025 Power BI update to learn about new features.
User | Count |
---|---|
82 | |
42 | |
31 | |
27 | |
27 |