Remove Empty Rows and Columns from tables by using Power Query custom functions. No need to load empty columns anymore.

Function:  Converts different date formats into YYYY-MM-DD or any other format that you define. You define it in code, it executes! Date column with mixed date formats Usage: = ConvertToISODate("03/13/2025") → Returns: "2025-03-13" Power Query code to use and reuse: let ConvertToISODate = (inputDate as any) as nullable text => let ConvertedDate = try Date.ToText(Date.From(inputDate), "yyyy-MM-dd") otherwise null in ConvertedDate Perfectly cleaned date