Forum Discussion

JWO16's avatar
JWO16
Frequent Visitor
3 years ago
Solved

Match formula in DAX (Excel formula alternative)

I've created a dashboard that in the main brings back info directly from another solution.  I've a few fields that I've had to create and use myself though.  The one I'm struggling with though is a field to flag when a field value is also in another record in the data (the parent column)

 

This is the formula I've used previously in my Excel workbook.  Is DAX capable of handling this and how could I go about doing the same so I can bring it into my PowerBI dashboard.

 

=IF(ISNUMBER(MATCH([@[Work Item ID]],[Parent Work Item Id],0)),"Y","N")

 

 

Need Help
  • ahmadibrahimbus's avatar
    ahmadibrahimbus
    3 years ago
    Please Use This Formula and mark my Answer as solution if it's Solved.
    = if(CALCULATE(COUNTROWS('Table'),FILTER( 'Table', 'Table'[Parent Work Item ID] = EARLIER('Table'[Work Item ID])))>0,"Y","N").
    Nb: include this dax formula as new calculated column.

1 Reply

  • ahmadibrahimbus's avatar
    ahmadibrahimbus
    Resolver III
    3 years ago
    Please Use This Formula and mark my Answer as solution if it's Solved.
    = if(CALCULATE(COUNTROWS('Table'),FILTER( 'Table', 'Table'[Parent Work Item ID] = EARLIER('Table'[Work Item ID])))>0,"Y","N").
    Nb: include this dax formula as new calculated column.