Forum Discussion
Yucy
Helper I
Helper INeed help on if statement DAX
Hello all, I have a small table with category and state, I am looking for a new column. Can anyone help? Example is below:
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
amitchandak
Super User
Super User
YucyHelper I
Helper IThanks, 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 |