Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Transaction fee calculation based on tiered pricing model

Hi all,   I'm looking for a way to calculate transaction fees based on tiered pricing model. This means that for each tier (see table 2 below), the tier rate is incrementally applied to the volume ...
ChandeepChhabra's avatar
ChandeepChhabra
Icon for Impactful Individual rankImpactful Individual
8 years ago

Anonymous Can you also share how your other table looks, which has transaction volumes ?

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Hi again, 

 

I've added a screenshot in which the format of the transaction fact table is visible (in blue). In orange, you'll see the current formula I'm using in Excel based on the Sumproduct function. I'm loolking for an alternative in PowerBI. Many thanks for your support

 

 

 

    • ChandeepChhabra's avatar
      ChandeepChhabra
      Icon for Impactful Individual rankImpactful Individual
      8 years ago

      Anonymous I corrected the month order in the powerbi file

       

      Thanks

      • Anonymous's avatar
        Anonymous
        Not applicable
        8 years ago

        ChandeepChhabra

         

        This is exactly what I was looking for. Many many thanks :)

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Icon for Super User rankSuper User
    8 years ago

    Hi,

     

    You may refer to my solution here.

     

    Hope this helps.