cancel
Showing results for
Did you mean:
Post Prodigy

## Measure For Table data changed

Hi,

I need a measure that the Logic is IF the Level from Table 1 is NOT EQUAL TO Level from Table 2 THEN "PROMOTION", If not THEN "" or BLANK

 Table 1 Table 2 Level Name Level Name 12 - Associate natalia 11 - Analyst natalia

How can I do this ?

Thanks

1 ACCEPTED SOLUTION
Community Support

How do the two tables relate?

If they have a relationship as below

Then you could create a measure like this

`Measure = IF(MAX(Table1[Level])<>MAX(Table2[Level]),"PROMOTION",BLANK())`

Best Regards
Maggie

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

3 REPLIES 3
Community Support

How do the two tables relate?

If they have a relationship as below

Then you could create a measure like this

`Measure = IF(MAX(Table1[Level])<>MAX(Table2[Level]),"PROMOTION",BLANK())`

Best Regards
Maggie

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Post Prodigy

It works but I need to add another variable to say that If column "Name" is equal then "yes". This is Because sometimes I have NEW people and in those cases the previous formula put yes to the promoted measure:

I tried but I donot know where is the error:

Promotion Q3 =
IF(AND(MAX(('Resource Forecast Q3'[Level Type]) <> MAX('Resource Actual'[Level Type])),
MAX(('Resource Forecast Q3'[Name]) = MAX('Resource Actual'[Name]))),
"YES",
BLANK ())

Thanks,

Frequent Visitor

I do not quite understand what you need, but you know the function ISINSCOPE. Returns true when the specified column is the level in a hierarchy of levels.

Announcements

#### Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

#### Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

#### Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

Top Solution Authors
Top Kudoed Authors