Remove finding-minimum-date-and-maximum-date-across-all-tables-in-power-query-in-power-bi-and-excel
article thumbnail

Finding Minimum Date and Maximum Date Across All Tables in Power Query in Power BI and Excel

BI Insight

When we talk about data analysis in Power BI, creating a Date table is inevitable. There are different methods to create a Date table either in DAX or in Power Query. In DAX you my use either CALENDAR() function or CALENDARAUTO() function to create the Date table.

article thumbnail

Finding Minimum Date and Maximum Date Across All Tables in Power Query in Power BI and Excel

BI Insight

When we talk about data analysis in Power BI, creating a Date table is inevitable. There are different methods to create a Date table either in DAX or in Power Query. In DAX you my use either CALENDAR() function or CALENDARAUTO() function to create the Date table.