Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi,
I want to calculate the amount paid by the customer after discount , I want to use two columns from two different tables, the other table has the discount and the other has the total. How do I go about doing that?
Thank you
Hi,
This approach should work
T = sum('Table1'[Total])
D = sum('Table2'[Discount])
N = [T]-[D]
Hope this helps.
User | Count |
---|---|
107 | |
89 | |
81 | |
76 | |
73 |
User | Count |
---|---|
112 | |
104 | |
96 | |
74 | |
66 |