Forum Discussion

Brookied's avatar
Brookied
Icon for Helper I rankHelper I
5 years ago
Solved

Tax Gross Up Calculation with DAX

Hi Guys I need to gross up an income amount to caulcate teh amount of tax i can claim per contact.   the caulcation is If you make a donation of €250, the approved body is deemed to have received...
Need Help
Tips and Tricks
  • v-yalanwu-msft's avatar
    v-yalanwu-msft
    5 years ago

    Hi, Brookied ;

    You could create a measure or column as follows:

    Column:

     

    gross donation = [donation]/(1-[percent])
    refund = [gross donation]*[percent]

     

    The final output is shown below:

    Measure:

     

    gross donation2 = MAX([donation])/(1-MAX([percent]))
    refund2 = [gross donation2]*MAX([percent])

     

     

     

    The final output is shown below:

    Best Regards,
    Community Support Team_ Yalan Wu
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-yalanwu-msft's avatar
v-yalanwu-msft
Icon for Community Support rankCommunity Support
5 years ago

Hi, Brookied ;

You could create a measure or column as follows:

Column:

 

gross donation = [donation]/(1-[percent])
refund = [gross donation]*[percent]

 

The final output is shown below:

Measure:

 

gross donation2 = MAX([donation])/(1-MAX([percent]))
refund2 = [gross donation2]*MAX([percent])

 

 

 

The final output is shown below:

Best Regards,
Community Support Team_ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Brookied's avatar
Brookied
Icon for Helper I rankHelper I
5 years ago

thats the badger - many thanks for that