Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hello everyone,
PBIX file : https://1drv.ms/u/s!Ag9tIyk2ofNRjlBFygNBL3s9VG2N?e=qoIeBc
Excel file: https://1drv.ms/x/s!Ag9tIyk2ofNRjk9-uND6F2ZLZgaZ?e=oAWQzt
I have tax table and expense table
to calculate tax, i need to do tax_rate * total_expense
the tax rate changes on october 1 so look:
on spetmebr 30 :
on october 1 :
when i selectseptemebr 30 and october 1 together, i dont get the correct sum of tax:
since 430.08 + 390 = 820.08 not 866.88
have can i fix?
Solved! Go to Solution.
Hi,
I am not sure if I understood your datamodel correctly, but please check the below measure.
Taxes =
SUMX (
SUMMARIZE ( Expense_Table, 'Calendar'[Date] ),
CALCULATE ( SUM ( Expense_Table[Total] ) )
* CALCULATE ( MAX ( New_Tax_Rate_Table[Percentage] ) )
)
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
Hi,
I am not sure if I understood your datamodel correctly, but please check the below measure.
Taxes =
SUMX (
SUMMARIZE ( Expense_Table, 'Calendar'[Date] ),
CALCULATE ( SUM ( Expense_Table[Total] ) )
* CALCULATE ( MAX ( New_Tax_Rate_Table[Percentage] ) )
)
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
User | Count |
---|---|
69 | |
42 | |
21 | |
21 | |
14 |
User | Count |
---|---|
124 | |
41 | |
39 | |
28 | |
24 |