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.
Hello all,
I have a small table with category and state, I am looking for a new column. Can anyone help? Example is below:
Solved! Go to Solution.
Try like
Column = var _res = COUNTX(filter(Sheet1,[State]="Resolved" && [Category] =EARLIER([Category])),[Category])+0
return if([State]="Resolved" && _res>0, [State],if([State]="Closed" && _res=0,[State],BLANK()))
File attached after signature
@Yucy ,
I'm still not understand of the logic of how to create 'new column' you mentioned, could you please clarify more details?
Regards,
Jimmy Tao
Thanks for helping, my table has column A and B, Category and State, I need to insert a new column as column C. my if statement never works,
@Yucy Can you provide more info on why some of the closed values in the state column correspond to a blank and why others correspond to closed
Sorry, my bad. The closed at new column for category C should be blank, but Closed at new column for category E should be closed because there is no resolved for E, then I want to keep the closed
Try like
Column = var _res = COUNTX(filter(Sheet1,[State]="Resolved" && [Category] =EARLIER([Category])),[Category])+0
return if([State]="Resolved" && _res>0, [State],if([State]="Closed" && _res=0,[State],BLANK()))
File attached after signature
Thank you for your help, however, it not working for me, maybe I did not provide enough data, Here is exactly what I have in my dataset, would you mind have a look again, I am sorry, thanks
case number | value | Opened | END | Column |
CS0080746 | Resolved | 1/20/2020 10:29 | 1/20/2020 11:03 | Closed |
CS0080746 | Resolved | 1/20/2020 10:29 | 1/23/2020 10:38 | Closed |
CS0080746 | Closed | 1/20/2020 10:29 | 1/31/2020 0:00 | Closed |
CS0080746 | Resolved | 1/20/2020 10:29 | 1/31/2020 0:00 | Closed |
CS0080772 | Resolved | 1/20/2020 10:54 | 1/21/2020 14:11 | Closed |
CS0080772 | Closed | 1/20/2020 10:54 | 2/01/2020 0:00 | Closed |
CS0080772 | Resolved | 1/20/2020 10:54 | 2/01/2020 0:00 | Closed |
CS0080798 | Closed | 1/20/2020 11:18 | 1/20/2020 13:22 | Closed |
CS0089655 | Closed | 2/13/2020 13:34 | 2/13/2020 13:35 | Closed |
Can you provide data in table format?
if you need more help mark me @
Appreciate your Kudos.
Thanks, here is the table
Category | State | New Column |
A | Resolved | Resolved |
A | Resolved | Resolved |
A | Closed | |
B | Resolved | Resolved |
B | Closed | |
C | Resolved | Resolved |
C | Closed | |
C | Closed | |
D | Resolved | Resolved |
D | Resolved | Resolved |
D | Closed | |
D | Resolved | Resolved |
D | Resolved | Resolved |
E | ||
E | Closed | Closed |
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
117 | |
107 | |
69 | |
68 | |
43 |
User | Count |
---|---|
148 | |
103 | |
103 | |
88 | |
66 |