Forum Discussion
dax issue
hi, i have a cost measure. from this measure i want to create a table where i can make an incremental 5 up / down of this measure. i use below measure, however when i change the date filter the...
Anonymous , Try using
Simulated Cost Table =
VAR BaseCost = CALCULATE([Cost]) -- use your selected base cost measure or variable
RETURN
ADDCOLUMNS(
GENERATESERIES(-5, 5, 1),
"BaseCost", BaseCost,
"SimulatedCost",
VAR Step = [Value]
RETURN BaseCost * (1 + Step * 0.05)
)