topic Re: Help with DAX code in DAX Commands and Tips

Help with DAX code

Anonymous — Fri, 28 May 2021 07:12:55 GMT

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 "dont check", then is 5658>5838 if yes "check" if no "dont check".

lbendlin — Sat, 29 May 2021 19:41:20 GMT

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 — Sat, 29 May 2021 21:21:31 GMT

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

lbendlin — Sat, 29 May 2021 21:27:28 GMT

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.