Summarize Columns from two tables

[rsbin]

Hello Folks,

Having difficulty with Summarize and/or Calculated Table.  I am trying to combine data from two tables:

1) DIM_Date_Tabular (Date Dimension Table) - Contains future dates to enable forecasting

2) HourlyStatisticsbyOperator (My Fact table)

= SUMMARIZE( FILTER( DIM_Date_Tabular, 
		         DIM_Date_Tabular[Date] <= Today() &&
		         DIM_Date_Tabular[Date] >= MIN(HourlyStatisticsByOperator[Date] )),
		         DIM_Date_Tabular[Date],
		         "WorkOrders", SUM(HourlyStatisticsByOperator[AllLiftWorkOrders] ))

 In my Fact Table, I have another column called "FacilityName".  I need to group my "WorkOrders" by FacilityName, so final result is as below:

Date	FacilityName	WorkOrders
9/13/2021	A	0
9/13/2021	B	0
9/13/2021	C	0
9/13/2021	D	0
9/13/2021	E	0
9/12/2021	A	336
9/12/2021	B	316
9/12/2021	C	214
9/12/2021	D	345
9/12/2021	E	359
9/11/2021	A	123
9/11/2021	B	456
9/11/2021	C	789
9/11/2021	D	224
9/11/2021	E	315

Any assistance would be much appreciated!

Thanks in advance and Best Regards

[amitchandak]

@rsbin , try like

SUMMARIZE( HourlyStatisticsByOperator,HourlyStatisticsByOperator[FacilityName],
DIM_Date_Tabular[Date],
"WorkOrders", calculate(SUM(HourlyStatisticsByOperator[AllLiftWorkOrders] )FILTER( DIM_Date_Tabular,
DIM_Date_Tabular[Date] <= Today() &&
DIM_Date_Tabular[Date] >= MIN(HourlyStatisticsByOperator[Date] )))

[rsbin]

Hi @amitchandak,

Thanks kindly for the prompt response.  Unfortunately, doesn't quite work the way I need it to.  I am not getting today's date in the table.  I'm guessing this is due to the fact Today's Date does not exist in my Fact Table.  Any suggestions on how to alter your solution?