Forum Discussion

Andrea78m's avatar
Andrea78m
Frequent Visitor
8 years ago
Solved

Listing data by date

Hi, when I connect a SQL server into Power BI, the date field(set as yyymmdd, es 20180102) becomes a SUM.   Pls can you help me? How can I change it and to have it like a date, and not like ...
  • v-yulgu-msft's avatar
    v-yulgu-msft
    8 years ago

    Hi Andrea78m,

     

    Add a new calculated column.

    Column2 =
LEFT ( Table2[Column1], 4 ) & "/"
    & RIGHT ( LEFT ( Table2[Column1], 6 ), 2 )
    & "/"
    & RIGHT ( Table2[Column1], 2 )

     

    Best regards,

    Yuliana Gu

Andrea78m's avatar
Andrea78m
Frequent Visitor
8 years ago

 

Unfortunately it gives me error

Maybe I'd modify the query in power BI?

Do you habe others idea to solve it?

v-yulgu-msft's avatar
v-yulgu-msft
Microsoft Employee
8 years ago

Hi Andrea78m,

 

Add a new calculated column.

Column2 =
LEFT ( Table2[Column1], 4 ) & "/"
    & RIGHT ( LEFT ( Table2[Column1], 6 ), 2 )
    & "/"
    & RIGHT ( Table2[Column1], 2 )

 

Best regards,

Yuliana Gu