Use the correct data type for a column. Don’t use a number for a boolean or a string for a date. Strongly consider adding CreatedAt and UpdatedAt timestamp fields to every table.

Once you decide the default Auto Date table isn’t adequate, you can create one that fulfills your grouping and filtering requirements in Microsoft Power BI.