Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Help with DAX code

  Hi  I have the table above and need to right an DAX if statement to checf if the early number in [Projected + 250 SMU] is greater than.    For example is 5838 > 7522 if yes "check" if no "...
  • lbendlin's avatar
    lbendlin
    5 years ago

    You need an index column for that so that you definitely know what "earlier"  actually means.  Is the  MachineNo field usable for that purpose?

lbendlin's avatar
lbendlin
Super User
5 years ago

in your measure:

 

- create a variable a that holds the current context machineno (via MAX() or SELECTEDVALUE() etc. )

- create a variable b to calculate the largest machineno that is smaller than your variable a

- calculate and return the "projected + 250" for that filter b.