Forum Discussion
rainchong7401
Helper III
Helper IIIHow to achieve such value
Hi Friends,
What I want to achieve is
Expected output for new column (BATCH_FILTER):
If "Con_BatchItem" has the same value and RANKED_ISSUE = 2 return "YES" into BATCH_FILTER
If "Con_BatchItem" not the same value and RANKED_ISSUE = 1 return "YES" into BATCH_FILTER
Else return "NO"
- Batch Filter = if(CALCULATE(MAX('Table'[Rank]),ALLEXCEPT('Table','Table'[Con_BatchItem]))='Table'[Rank],"YES","NO")
Regards,
Ritesh
Mark my post as a solution if it helped you| Munde and Kudis (Ladies and Gentlemen) I like your Kudos!! !!
My YT Channel Dancing With Data !! Connect on Linkedin !! PL 300 Certification Series
1 Reply
- ribisht17
Super User
Batch Filter = if(CALCULATE(MAX('Table'[Rank]),ALLEXCEPT('Table','Table'[Con_BatchItem]))='Table'[Rank],"YES","NO")Regards,
Ritesh
Mark my post as a solution if it helped you| Munde and Kudis (Ladies and Gentlemen) I like your Kudos!! !!
My YT Channel Dancing With Data !! Connect on Linkedin !! PL 300 Certification Series