Results 1 to 2 of 2

Thread: Power Pivot or Power Query to show all claim lines for a customer with a specific event
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    Board Regular
    Join Date
    Aug 2012
    Posts
    81
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Power Pivot or Power Query to show all claim lines for a customer with a specific event

    I have a spreadsheet with multiple claim lines per day for various events taking place per customer.

    I am looking for either a Power Query or Power Pivot solution to show all claim lines for only dates where a particular event took place on one of the claim lines.

    For example, if customer ID 1111A had event "45456A" take place on 1/1/2012, I want to see all claim lines for 1/1/2012 for that customer. But, if on 4/1/2012 customer 1111A had five claim lines for that day with no events equaled 45456A, then I want none of those claim lines to appear.

    Using Excel 365 and tried using a PowerPivot measure to flag rows, but no luck. Any ideas?

    See link below for sample spreadsheet. Thanks.

    https://drive.google.com/file/d/1oFY...ew?usp=sharing

  2. #2
    MrExcel MVP
    Join Date
    May 2006
    Location
    Excel 2003, Australia
    Posts
    9,154
    Post Thanks / Like
    Mentioned
    7 Post(s)
    Tagged
    3 Thread(s)

    Default Re: Power Pivot or Power Query to show all claim lines for a customer with a specific event

    maybe this helps. This is one way to do it in a normal pivot table, or query table.

    Code:
    SELECT A.[Date], A.Customer, A.Event, A.[Amt Paid]
    FROM [Data$] A
    WHERE A.[Date] IN 
    (SELECT DISTINCT B.[Date]
    FROM [Data$] B
    WHERE B.Event = '45456A')
    To receive a better answer, put more work into asking the question.


Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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