How to convert date to year ?

[Paulyeo11]

Hi All

I have Raw data below :-

Date

12/2/2020

20/12/2019

My excepted result :-

Year,motn,Date

2020,2,12/2/2020

2019.12.2019

Hoep some one can advise me.

Paul Yeo

[Anonymous]

@Paulyeo11 @Pragati11 @Anonymous  @amitchandak 

You Have to create a new column .

Write below formula 

New Date = Format(table1[date], "YYYY.mm.dd")

This code is more efficiant  and let you modify your date as per your requirement .

You will get the desired result .

Give kudos if is it work for you .

[Anonymous]

@Paulyeo11 Duplicate the date column (twice) in Power Query editor and transform to Year, Month no.. As Power Query supports 2 columns to merge at once, first merge would be on Year and Month no. and next merge will be of resultant column (year,monthno.) with Date.

Please mind the sequence you select the columns to merge.

[amitchandak]

@Paulyeo11 ,

year = right([column],4)

Month =
var _pos = search("/",[column],,0)
return
mid([column],_pos+1,2)

new date =
var _pos = search("/",[column],,0)
return
date(right([column],4), mid([column],_pos+1,2), left([column],_pos-1))

[Paulyeo11]

Hi Amit

I get error msg :-

[Pragati11]

Hi @Paulyeo11 ,

You can create new columns for YEAR and MONTH using DAX as follows:

yearCol = YEAR(tablename[Date])

monthCol = MONTH(tablename[Date])

Replace tablename[Date] in the above DAX expressions with your table name and date column name.

Thanks,

Pragati

[Paulyeo11]

Hi Miss ,  Can you share how to start DAX ?

[Pragati11]

Hi @Paulyeo11 ,

You don't have to start DAX. It's in Power BI only. Just see the GIF below on how you can create a dax calculation:

Check the following link to go through starting with DAX in Power BI:

https://docs.microsoft.com/en-us/power-bi/transform-model/desktop-quickstart-learn-dax-basics

Thanks,

Pragati

[Paulyeo11]

Hi Miss 

Thank you for sharing the link . Now more lady start to like data visulisation. it use to be for man only.

Paul Yeo

[lbendlin]

@Paulyeo11 That statement would have been inappropriate back in 1960, and it is very inappropriate today. I think you want to apologize to @Pragati11 .