Greetings. This formula works great in Excel. Can you help me with an expression that will do the same thing in a Dax environment / Power Pivot?
Column A = Claim number
Column B = the part that the customer ordered
Column C = whether or not the part is a frame related part
As you can see, part x and part q are frame related parts; the others are not.
Column D is where I'm asking for help.
If any line in a given claim number contains a frame related part, then every line of that claim is part of a frame related claim.
The formula you see is in column D and works great in Excel, but the COUNTIFS expression is not allowed in PowerPivot.
=IF(COUNTIFS($A$2:$A$999999,A2,$C$2:$C$999999,"FramePart"),"FrameClaim2","")
Thanks in advance to all interested.
130910 a.jpg
Bookmarks