Forum Discussion
Helper ITax 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 a gross donation. The gross donation is calculated as follows:
€250/(100%-31%)=€362.32. The approved body can claim a refund of €112.32 which is €362.32x31%.
I have the sum of each contact but the above has me stummped...
Thanks in advance
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.
3 Replies
v-yalanwu-msftCommunity Support
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.
Brookiedthats the badger - many thanks for that
- amitchandak
Super User
Brookied , Following as new column or measure depending on what you have
A1 = [Column/measure]/.69
A2 = [A1]*.31
