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
Hello Community,
I am trying to achieve the result below,
Requirements
1.First I want to find same order number
Dataset
Order Number | Parts |
123 | ABC |
123 | DEF |
456 | LMN |
456 | DEF |
789 | DEF |
Expected Result
Order Number | Parts | Category |
123 | ABC | Connected |
123 | DEF | Connected |
456 | LMN | Not-Connected |
456 | DEF | Not-Connected |
789 | DEF | Single |
Solved! Go to Solution.
pls try this
Column = IF('Table'[Parts]="DEF",if(CALCULATE(count('Table'[Parts]),ALLEXCEPT('Table','Table'[Order Number]))=1,"Single",if(maxx(FILTER('Table','Table'[Order Number]=EARLIER('Table'[Order Number])&&'Table'[Parts]="ABC"),'Table'[Parts])<>"","Connected","Not_Connected")),if('Table'[Parts]="ABC"&&maxx(FILTER('Table','Table'[Order Number]=EARLIER('Table'[Order Number])&&'Table'[Parts]="DEF"),'Table'[Parts])<>"","Coneected","Not_Connected"))
Proud to be a Super User!
hello@tejapowerbi123
caluclated column :
let me know if it works out for you .
If my response has successfully addressed your issue kindly consider marking it as the accepted solution! This will help others find it quickly. Dont forget to hit that thumbs up button 🫡👍
@ryan_mayu @Daniel29195
I want to say thank you so much to both of you. I have tried both solutions, which work perfectly for my massive data.
you are welcome
Proud to be a Super User!
hello@tejapowerbi123
caluclated column :
let me know if it works out for you .
If my response has successfully addressed your issue kindly consider marking it as the accepted solution! This will help others find it quickly. Dont forget to hit that thumbs up button 🫡👍
pls try this
Column = IF('Table'[Parts]="DEF",if(CALCULATE(count('Table'[Parts]),ALLEXCEPT('Table','Table'[Order Number]))=1,"Single",if(maxx(FILTER('Table','Table'[Order Number]=EARLIER('Table'[Order Number])&&'Table'[Parts]="ABC"),'Table'[Parts])<>"","Connected","Not_Connected")),if('Table'[Parts]="ABC"&&maxx(FILTER('Table','Table'[Order Number]=EARLIER('Table'[Order Number])&&'Table'[Parts]="DEF"),'Table'[Parts])<>"","Coneected","Not_Connected"))
Proud to be a Super User!
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 |
---|---|
110 | |
107 | |
105 | |
89 | |
61 |
User | Count |
---|---|
169 | |
138 | |
135 | |
102 | |
86 |