Forum Discussion
Summarize Columns from two tables
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 for...
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] )))
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?