Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

DAX conditional Column based on the same column value with multiple rows

Hi all,   I'd like to create a DAX column which returns a text value with rules. If Category = "Done", then "Good" If for the same Account value (for example A with multiple rows) Category = "Do...
Need Help
Show and Tell
Tips and Tricks
  • Fowmy's avatar
    Fowmy
    5 years ago

    Anonymous 

    Add the following code as anew column to your table:

    Defined = 
IF( 
    ISEMPTY( FILTER( Accounts , Accounts[Account] = EARLIER(Accounts[Account]) && Accounts[Category] = "Done")),
    "In Progress",
    "Done"
)

     

    ________________________

    If my answer was helpful, please consider Accept it as the solution to help the other members find it

    Click on the Thumbs-Up icon if you like this reply 🙂

    YouTube  LinkedIn

     



FrankAT's avatar
FrankAT
Community Champion
5 years ago

Hi Anonymous 

take a look at the folowing solution:

 

 

Defined = 
VAR _Text = CONCATENATEX(VALUES('Table'[Category]),'Table'[Category])
RETURN
    SWITCH(TRUE(),
        _Text = "Done" , "Good",
        _Text = "Unfinished" , "In Progress",
        "Good"
    )

 

With kind regards from the town where the legend of the 'Pied Piper of Hamelin' is at home
FrankAT (Proud to be a Datanaut)

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    mahoneypat Thx, but didn't work.

    @FrankAT

    thanks. I tried the same solution, but in my case Account C is still "Good" instead of "In Progress".

    What is different in my new column?