How to make Lists from Date column.

Question

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

samwiseowl · Answer

Hi&nbsp;ealiisl&nbsp;What does the data look like?If something like this you can tell the data to pivot.&nbsp;

ryan_mayu · Answer

pls provide some sample data and expected output

ealiisl · Answer

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.&nbsp;&nbsp;

bibiano_geraldo · Answer

Hi,Create a new Calculated column by this DAX Code:YearColumn = YEAR('YourTable'[DateColumn])&nbsp;Or by:YearColumn = FORMAT('YourTable'[DateColumn],"Yyyy")

Forum Discussion

How to make Lists from Date column.

4 Replies

Related content

Sharepoint list mirroring

How to make a 1-20 column

Make Parameter effective using calculated column

Column Item Showing as [list]

Expand list with records to columns