Forum Discussion
Updating data from a table with what-if parameter
Hi everyone, So I have to build a table with demand, production, initial stock and final stock like this: And i have a what-if parameter that is able to change the value of production on ...
SivaMani
Resident Rockstar
Resident RockstarAnonymous,
Create measure for Production
Production =
VAR firstDate = CALCULATE(MIN(<Date Column>), ALL(<Date Column>)
VAR currentDate = MAX(<Date Column>)
VAR ProdValue = CALCULATE(SUM(Table{Value]), Table[Detail]="Production")
VAR dynValue = <What-if Measure>
RETURN
IF(currentDate = firstDate, ProdValue + dynValue, ProdValue )