Forum Discussion

Khomotjo's avatar
Khomotjo
Icon for Helper II rankHelper II
1 year ago
Solved

Format Date_Time

Morning I have a date_time field and I want to  only the date Field. This is the original data :      This is the table when I format and select short date , The issue is that Power Bi still...
Need Help
  • danextian's avatar
    danextian
    1 year ago

    You are seeing multiple dates because you simply changed the display or formatting but not the actual data type. Several methods to extract the date:

     

     

     

  • Anonymous's avatar
    Anonymous
    1 year ago

    Hi Khomotjo ,

     

    Thanks to danextian  and uzuntasgokberk  for their quick answers. I have some other thoughts to add:
    (1) Here is my test data.

    (2) Create a calculation table. Select the Date column to change the data type.

    Table =
ADDCOLUMNS (
    SUMMARIZE ( 'Table_3', [FinalisedDate], [id] ),
    "date",
        DATE ( YEAR ( [FinalisedDate] ), MONTH ( [FinalisedDate] ), DAY ( [FinalisedDate] ) )
)

     

    Best Regards,

    Neeko Tang

    If this post  helps, then please consider Accept it as the solution  to help the other members find it more quickly. 

uzuntasgokberk's avatar
uzuntasgokberk
Icon for Super User rankSuper User
1 year ago

Hello Khomotjo ,

Could you please try that navigate to Power Query(Transform Data), select Finalised_Date, Change Data Type to "Date/Time", Change Data Type "Date" and remove duplicates. This way is more performance and effective way.

 

Here is the example:

 

let
  Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WMjIwMtE3MNc3MlMwNLMyNrcyMFOKjQUA", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [#"Date Time" = _t]),
  #"Changed column type" = Table.TransformColumnTypes(Source, {{"Date Time", type datetime}}),
  #"Changed column type 1" = Table.TransformColumnTypes(#"Changed column type", {{"Date Time", type date}}),
  #"Removed duplicates" = Table.Distinct(#"Changed column type 1", {"Date Time"})
in
  #"Removed duplicates"

 

 

 

Kind Regards,
Gökberk Uzuntaş

📌 If this post helps, then please consider Accepting it as a solution and giving Kudos — it helps other members find answers faster!

🔗 Stay Connected:
📘 Medium |
📺 YouTube |
💼 LinkedIn |
📷 Instagram |
🐦 X |
👽 Reddit |
🌐 Website |
🎵 TikTok |