Increased data size after new date column

Hey , 
Please Look for following points

• Remove the time portion from the column if not needed, keeping only the date.
• Convert the column to an integer format, such as YYYYMMDD, to save space.
• Change the data type to Date instead of DateTime if time values are unnecessary.
• Aggregate or summarize the data to a higher level, such as monthly or yearly, if detailed dates are not required.
• Archive older data into a separate dataset if it is less frequently accessed.
• Sort the column to improve VertiPaq compression efficiency.

  Best Regards,
  Govind Sapkade
  Data Analyst | Power BI Enthusiast | Microsoft PL 300 Certified Power BI Data Analyst | MS Fabric Enthusiast
  🎥 Subscribe to my youtube channel for hands on tutorials : You Tube

  📊 Let’s connect on Linkdin : Linkdin