Forum Discussion
Beno1234
9 years agoFrequent Visitor
STDEV and SUMMARIZE HELP!
HI, im trying to get the STDev of a sumarized table, I tried the measure in the photo, It gives me the number Im looking for, but I cant display it in the Graph. I need to apply filters o...
- 9 years ago
I found the answer,
It only needed a CALCULATE
STD = calculate(STDEVX.S(SUMMARIZE(Sheet1,Sheet1[FECHA],"VENTAS",sum(Sheet1[VALOR])),[VENTAS]),Sheet1[FECHA])
:smileylol:
Beno1234
9 years agoFrequent Visitor
I found the answer,
It only needed a CALCULATE
STD = calculate(STDEVX.S(SUMMARIZE(Sheet1,Sheet1[FECHA],"VENTAS",sum(Sheet1[VALOR])),[VENTAS]),Sheet1[FECHA])
:smileylol: