Forum Discussion
add growth column in table
I have dataset in table 1, then I make table 2 in powerbi. How can I make growth colu
I edited your formula SUM(T1[Sales]) with SUMX(T1,[YTD]). I use SUMX because YTD is a measure, not column.
It can run when I use small data. But when I use bigger data, there's warning like "power bi couldn't load the data for this visual not enough memory"
Measure 2 =
VAR currYear =
SELECTEDVALUE ( T2[Year] )
RETURN
IF (
ISFILTERED ( T2[Year] )
&& currYear <> "Growth",
CALCULATE (
SUMX ( T1,[YTD] ),
FILTER ( ALLSELECTED ( T1 ), [Year] = VALUE ( currYear ) ),
VALUES ( T1[Quarter] ),
VALUES ( T1[ID] )
),
VAR list =
SELECTCOLUMNS (
EXCEPT ( ALL ( T2[Year] ), VALUES ( T2[Year] ) ),
"Y", VALUE ( [Year] )
)
VAR _min =
CALCULATE (
SUMX ( T1,[YTD] ),
FILTER ( ALLSELECTED ( T1 ), [Year] = MINX ( list, [Y] ) ),
VALUES ( T1[Quarter] ),
VALUES ( T1[ID] )
)
VAR _max =
CALCULATE (
SUMX ( T1,[YTD] ),
FILTER ( ALLSELECTED ( T1 ), [Year] = MAXX ( list, [Y] ) ),
VALUES ( T1[Quarter] ),
VALUES ( T1[ID] )
)
RETURN
DIVIDE ( _max - _min, _min )
)
HI basyaiban ,
Can you please share a sample pbix file for test? It is hard to test without any detail data.
Notice: do mask on sensitive data before share.
Regards,
Xiaoxin Sheng