Conditional Measure

[JaclynPugh2022]

Hi,

I have a calculated column 'PPO Open Conf and Rec'[Past or Future] that indicates Past or Future based on report name.  I am trying to create a conditional measure that calculates [STD PPV in ths] if [Past or Future]="Past", otherwise i want it to calculate [PPV Forecast].  Can someone help me create this conditional measure please?

[JaclynPugh2022]

Thank you!!

[Tutu_in_YYC · Accepted solution]

Use the DAX function IF. You can find the syntaxt and example here:
https://dax.guide/if

Measure=
IF(
  SELECTEDVALUE('PPO Open Conf and Rec'[Past or Future]) = "Past",
  [STD PPV in ths],
  [PPV Forecast]
)