Load dates based on other tables

[antmat]

Hi! We have a Date Table (Calendar) in our Data warehouse, with dates from 2008-2017. But in some reports we only want to load dates based on the other imported data, ex. "min(sales date)" to "max(sales date"). Is this possible? Or should we think different when using Date tables in Power BI?

Thanks!

[v-shex-msft]

Hi antmat,

>>The problem is that our Azure Datawarehouse already have a complete Date table, which we would like to use.

Based on your description, you already had a date table, you want to know how to use it to get a specify dynamic date table, right?

If it is a case, you could take a look at below steps:

1. Create tables.

Calendar table.(your date table form azure warehouse)

 

Specify table with date column.

 

2. Create the new table with minimum and maximum date from the specify  

Table = FILTER(CALENDARTable,AND(CALENDARTable[Date]>=FIRSTDATE(Sheet1[Date]),CALENDARTable[Date]<=LASTDATE(Sheet1[Date])))

 

Regards,

Xiaoxin Sheng

[BhaveshPatel]

Hi Antmat,

This post on PowerBI community will provide you the best guidance and use of DAX to create a Dynamic Date Table.

https://community.powerbi.com/t5/Desktop/Possible-Tip-Trick-Dynamic-Date-Dimension-Table/td-p/8462

Best Regards,

Bhavesh

[antmat]

Hi 

Thanks, but I already know how to create a dynamic date table in PowerBI. The problem is that our Azure Datawarehouse already have a complete Date table, which we would like to use.