Forum Discussion
Solved
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 on it, thats why I cant create a real table.
PD: The real table is in the right side.
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:
1 Reply
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: