Share
Report
40New user here!
test = AVERAGEX('Weekly Report','Weekly Report'[Days In-Office/Travel]+'Weekly Report'[Holidays in selected period]+'Weekly Report'[Days with Time Away])
test = AVERAGEX('Weekly Report','Weekly Report'[Days In-Office/Travel]+'Weekly Report'[Holidays in selected period]+'Weekly Report'[Days with Time Away])
I am trying to get average of 3 columns by row.
My understanding was the x function(averagex, sumx, countx) were used to provided calculation by row and not for the whole column data.
Though this providing a total average instead of individual average.
My understanding was the x function(averagex, sumx, countx) were used to provided calculation by row and not for the whole column data.
Though this providing a total average instead of individual average.
Categories:
I have the same question (0)
All responses (
Answers (
