sql date format to bi

[Anonymous]

Hi

below  is the format  for date sql, can  I show this as date in period in power bi.or I can get only year and month in bi

Date Period

202002

202002

202002

202002

202002

[Sumanth_23 · Accepted solution]

hi @Anonymous - you can use calculated columns to do the same as seen in screen grabs below

Year = FORMAT(LEFT(Date_Period[Date Period], 4), "YYYY")

Month = FORMAT(MID(Date_Period[Date Period],5, 2), "MMM")

Date = DATE(Date_Period[Year], Date_Period[Month], 1)

Hardcoding the "Day" of each month as 1 to convert to a date field 

Please mark the post as a solution and provide a 👍 if my comment helped with solving your issue. Thanks!