Forum Discussion

Yucy's avatar
Yucy
Icon for Helper I rankHelper I
6 years ago
Solved

Need 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:  
Need Help
  • amitchandak's avatar
    amitchandak
    6 years ago

    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's avatar
Yucy
Icon for Helper I rankHelper I
6 years ago

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

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
6 years ago

Yucy 

Can you provide data in table format?

 

if you need more help mark me @

Appreciate your Kudos.

 

  • Yucy's avatar
    Yucy
    Icon for Helper I rankHelper I
    6 years ago

    Thanks, here is the table

    CategoryStateNew Column
    AResolvedResolved
    AResolvedResolved
    AClosed 
    BResolvedResolved
    BClosed 
    CResolvedResolved
    CClosed 
    CClosed 
    DResolvedResolved
    DResolvedResolved
    DClosed 
    DResolvedResolved
    DResolvedResolved
    E  
    EClosedClosed

    amitchandak