Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
JaclynPugh2022
Helper II
Helper II

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?

 

JaclynPugh2022_0-1667846023750.png

 

1 ACCEPTED SOLUTION
Tutu_in_YYC
Resident Rockstar
Resident Rockstar

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]
)

View solution in original post

2 REPLIES 2
JaclynPugh2022
Helper II
Helper II

Thank you!!

Tutu_in_YYC
Resident Rockstar
Resident Rockstar

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]
)

Helpful resources

Announcements
PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.