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?

Anonymous's avatar
Anonymous
Not applicable
5 years ago

lbendlin Yes [machineno] could be used as an index.