Power BI Exchange

Please login or click SIGN UP FOR FREE to create your PowerBIUG account to join this user group.
  • 1.  Cumlative Help Needed

    Posted 2 days ago
    Hello I'm working with a Large Data set - over 1 million rows from "2" separate databases.  I'm trying to apply a "tier" level Rebate BY Customer for overall total spend.

    Example:  This will work like Kohl's cash program.  If a customer spends X dollars then the Rebate for that customer is X dollars.  This will vary by customers and is not a static percentage same amount for every customer.

    I have the Cumulative Total by customer measure already (see below).

    I need help applying the Discount Tier (below) to individual customers.  The customer discount will vary By customer and by Total Amount Spend.


    Customer Cumulative Example: Running Totals by Customers

    image.png

    Rebate Table per customer:


    image.png

    How to calculate a Measure or Column  when the customer reaches the next tier rebate level by total sales then apply the rebate percentage changes based on total spend by individual customers.
    I have 100 hundred customers on this Rebate Tier Programs and doing this as a single measure for each will be impossible.

    Again this is an extremely large data set with millions of rows of data.

    HELP 

    Thank you
    Train 23