From time extract and create month in 1 column extract and year in 1 column

[dd88]

in powerbi column/field 

start-time

format as
18/12/2024 8:51:01 AM

From column start-time, how to extract the month and create & place in one column. and then extract year and create and place in another column, to allow to filter on months & years please

any info on this would be great.

TIA

[danextian · Accepted solution]

Hi @dd88 

In the query editor, select the datetime column and then go to add columns tab. Select one of the transformations available  from the date button

[dd88]

That worked. Many thanks @danextian