How to make Lists from Date column.

[ealiisl]

I have a one column with dates from year 2021 to year 2024. From this, how can i make seprate columns for each year. 

[Bibiano_Geraldo]

Hi,
Create a new Calculated column by this DAX Code:

YearColumn = YEAR('YourTable'[DateColumn])

Or by:

YearColumn = FORMAT('YourTable'[DateColumn],"Yyyy")

[ryan_mayu]

pls provide some sample data and expected output

[SamWiseOwl]

Hi @ealiisl 
What does the data look like?

If something like this you can tell the data to pivot.

[ealiisl]

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.