Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to Solution.
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.
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.
thats the badger - many thanks for that
@Brookied , Following as new column or measure depending on what you have
A1 = [Column/measure]/.69
A2 = [A1]*.31
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
100 | |
76 | |
64 | |
63 |
User | Count |
---|---|
140 | |
105 | |
102 | |
81 | |
67 |