+ Reply to Thread
Results 1 to 2 of 2

Help make my Excel formula work in Power Pivot / Dax language

  1. #1
    Registered User
    Join Date
    09-10-2013
    Location
    Virginia, USA
    MS-Off Ver
    Excel 2013
    Posts
    3

    Help make my Excel formula work in Power Pivot / Dax language

    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
    Last edited by Paul Reins; 09-11-2013 at 02:44 PM.

  2. #2
    Forum Guru JosephP's Avatar
    Join Date
    03-27-2012
    Location
    Ut
    MS-Off Ver
    2003/10
    Posts
    7,328

    Re: Help make my Excel formula work in Power Pivot / Dax language

    perhaps
    =if(countrows(filter(table1,[ExtClaimNo]=earlier([ExtClaimNo])&&[FramePart]="FramePart"))>0,"FramePart2",blank())
    Josie

    if at first you don't succeed try doing it the way your wife told you to

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Excel career: macros or power-pivot?
    By Gry in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 09-03-2013, 10:48 AM
  2. how to make excel a learning tool for foreign language learners
    By aTOzb in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-22-2013, 05:29 PM
  3. Date formats in pivot tables using power pivot in Excel 2010.
    By myobreportguru in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 03-25-2013, 10:21 PM
  4. Power Pivot with multiple pivot charts using different pivot data
    By Paul-NYS in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 01-10-2013, 10:18 AM
  5. How do you cut a paste a macro or VB language in Excel and make it
    By Angela in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 12-08-2005, 05:50 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1