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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Helper I
Helper I

Multiple conditions

I want to create a conditional custom in Power Query:

I have given the sample data and expected output:

Month (text)    Emp id        Segment         Segment Transfer(Expected Output)
2023 01              Ab             Sales                 0
 2023 12             Ab              Sales                 0

2023 01              AC             Sales               -1

2023 02            Ac             Marketing          1

For example:

If Month = 2023 01 , emp id = abc and segment = "sales" compare this all the other months data if segment for the respective emp id changes look at the previous month for example if it changes at 5 th month the 4th month of the emp  id should be "-1" and 5 th month should be "1" if no changes "0". The "-1","0","1" should be the Segment Transfer column i need to create.

HELP ME out for this one if someone knows it!

Super User
Super User

what are the conditions? write

Helpful resources

Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City


Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.