cancel
Showing results 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

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

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.