Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

sql date format to bi

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 ...
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    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!

     

     

Anonymous's avatar
Anonymous
Not applicable
6 years ago

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!