Hi
i have this to return a table
ADDCOLUMNS(CROSSJOIN(Pattern,Budget),"RevBud",Pattern[%]*Budget[Budget])
how can i add [RevBud]
i tried this =calculate(sum([RevBud]),ADDCOLUMNS(CROSSJOIN(Pattern,Budget),"RevBud",Pattern[%]*Budget[Budget]))
i have this to return a table
ADDCOLUMNS(CROSSJOIN(Pattern,Budget),"RevBud",Pattern[%]*Budget[Budget])
how can i add [RevBud]
i tried this =calculate(sum([RevBud]),ADDCOLUMNS(CROSSJOIN(Pattern,Budget),"RevBud",Pattern[%]*Budget[Budget]))