Forum Discussion

LilMurph's avatar
LilMurph
Frequent Visitor
4 years ago
Solved

Using What-If modeling parameters

Hi All   I have a table where one column specifies the week as 1, 2, 3 etc. Another column specifies a job by specific code i.e. ABC-123, ABC-578, CCA-246 etc. And a third column showing how many h...
  • amitchandak's avatar
    4 years ago

    LilMurph , Based on what I got, Add a What if slicer you will get a measure that will give you what is value

    hope weeks is the number

    you can create a measure 

    sumx(Table, [ParamValue] - Table[Weeks])