Forum Discussion

ronaldbalza2023's avatar
ronaldbalza2023
Continued Contributor
4 years ago
Solved

Dax Measure

Hi everyone, would like to have a DAX measure in the following scenario below. Appreciated your help on this in advance 🙂   Problem statement: Basically, I am tracking if the target revenue is met...
Need Help
Show and Tell
Tips and Tricks
  • v-angzheng-msft's avatar
    v-angzheng-msft
    4 years ago

    There, @ronaldbalza2023

    It looks like you have the solution in another thread you posted.

    IF revenue > target in Q1

    THEN Revenue Q2 = Revenue

    ELSE revenue < target in Q1

    THEN Revenue Q2 = Revenue minus Target

    Assuming you have only selected 1 year:

    Projected revenue =

    VAR _SelectedQuarter = SELECTEDVALUE(DimDate[Quarter])

    RETURN

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

    if this question has been resolved consider marking this thread as answered due to thread duplication

    https://community.powerbi.com/t5/Desktop/DAX-Measure/m-p/2331876

    Best regards
    Community Support Team _ Zeon Zheng

    If this post helps, consider Accepting it as the solution to help other members find it more quickly.

v-angzheng-msft's avatar
v-angzheng-msft
Community Support
4 years ago

There, @ronaldbalza2023

It looks like you have the solution in another thread you posted.

IF revenue > target in Q1

THEN Revenue Q2 = Revenue

ELSE revenue < target in Q1

THEN Revenue Q2 = Revenue minus Target

Assuming you have only selected 1 year:

Projected revenue =

VAR _SelectedQuarter = SELECTEDVALUE(DimDate[Quarter])

RETURN

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

if this question has been resolved consider marking this thread as answered due to thread duplication

https://community.powerbi.com/t5/Desktop/DAX-Measure/m-p/2331876

Best regards
Community Support Team _ Zeon Zheng

If this post helps, consider Accepting it as the solution to help other members find it more quickly.