Forum Discussion
Conditional Measure
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?
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]
)
2 Replies
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]
)Thank you!!
