Forum Discussion
Monthly averages issue
Hi all I have a problem with monthly averages : My underlying data is rolled up at a monthly level but one key parameter is the average daily volume. This is calculated on a workday basis su...
Hi
Sadly as the mock up of the data didn't account for the fact that the attrubtes repeat in the months and so it is summing the numerator correctly but then dividing but multiple sums of the workdays, rather than one. I have tried the "distinct" function and it does not like that in sum functions, nor does it allow me to sum related columns. It works as a calculated column, but then the aggregation doesn't.
sorry for the original dataset issue....
amitchandak
Super User
Super UserNPH2020 , Try
Divide(Sum(Tabel1[Value]), sumX(Summarize(Table2, Table2[EOM],"_1" ,max(Table2[Work day])),[_1]))