Forum Discussion

rsbin's avatar
rsbin
Community Champion
4 years ago

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...
Need Help
amitchandak's avatar
amitchandak
Super User
4 years ago

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] )))