DAX Measure

[ronaldbalza2023]

Hi everyone, could someone translate this into DAX, please. Appreciated the help in advance 🙂

Q1, Q2 is based on the selected value of a quarter

IF Revenue > Target in Q1

   THEN Revenue Q2 = Revenue

ELSE Revenue < Target in Q1

  THEN Revenue Q2 = Revenue minus Target

Attached is the sample data 🙂 https://www.dropbox.com/s/vud41owacppamfw/Sample%20Data.pbix?dl=0 

[AllisonKennedy · Accepted solution]

@ronaldbalza2023  If I understand you correctly: 

IF Revenue > Target in Q1

   THEN Revenue Q2 = Revenue

ELSE Revenue < Target in Q1

  THEN Revenue Q2 = Revenue minus Target

Assuming you have only 1 year selected:

Projected Revenue = 

VAR _SelectedQuarter = SELECTEDVALUE(DimDate[Quarter])

RETURN

IF( [Revenue] > [Target] , [Revenue], [Revenue] - [Target] )

This will create a measure, so not sure how you want to use this ultimately. Does it need to be cumulative?

[AllisonKennedy]

@ronaldbalza2023  If I understand you correctly: 

IF Revenue > Target in Q1

   THEN Revenue Q2 = Revenue

ELSE Revenue < Target in Q1

  THEN Revenue Q2 = Revenue minus Target

Assuming you have only 1 year selected:

Projected Revenue = 

VAR _SelectedQuarter = SELECTEDVALUE(DimDate[Quarter])

RETURN

IF( [Revenue] > [Target] , [Revenue], [Revenue] - [Target] )

This will create a measure, so not sure how you want to use this ultimately. Does it need to be cumulative?