Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
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!
what are the conditions? write
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
112 | |
89 | |
82 | |
76 | |
64 |
User | Count |
---|---|
142 | |
111 | |
108 | |
99 | |
95 |