Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi All
I have a transaction table, contact many columns include gross sales "Vales" and Discount "Value" is the discount percentage.
Example:
Gross Sales = 100.00
Discount= 5.00 "This value have to baclulated as percentage"
The result = 95.00
Thanks in advance.
Hi All
Thanks for supporting all, both (Measure and Column) of this giving me the total amount, My DB each item has Gross sales value and I need to get each item value.
Here is the total Gross sales for Store#10 from starting of the year the measure or column not filtring with date or any there field.
FYI
Table has :
Area
Store#
SalesDate
cashier#
transaction#
barcode
Thanks again for all of the advising and supporting, which to get what I am looking for.
Regards
New column = ((100 -[Discount]) *[Gross Sales])/100
User | Count |
---|---|
42 | |
28 | |
24 | |
20 | |
16 |
User | Count |
---|---|
54 | |
35 | |
18 | |
18 | |
15 |