Create a date table based on a date range in Power BI

Question

I want to create a date table based on the current dates available in your tables for example .. created date startd from 01-01-2020 till 30-06-2020

Answer 1

If you want to create a date table based on the current dates available in your tables, you can use the MIN and MAX functions to determine the minimum and maximum dates in your dataset and then generate a date table based on that range.

DateTable = CALENDAR(MIN('YourTableName'[DateColumn]), MAX('YourTableName'[DateColumn]))