Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
I need to set up an invoicing calculation that has a price for the first 50 items at $50 then any other item will be $40, how do I set up such multiplication?
Solved! Go to Solution.
Your phrase "first 50 items" is the key to the sulution. Please clarify or as @ryan_mayu suggested please provide a data sample. Meanwhile, assuming your invoices are numeric and not alpha numeric then you can create a calculated coumn with a simple condition below (Mulitplier Column)
Multiplier = IF('Table'[Invoice #] >= 2050, 40, 50)
you can hardcode the condition value as I did in my case 2000+ 50 , or
create a use MIN() function to pull the min value and add 50
MIN('Table'[Invoice #])+50
Multiplier = IF('Table'[Invoice #] >= MIN('Table'[Invoice #])+50, 40, 50)
Multiplied Amount = 'Table'[Amount] * 'Table'[Multiplier]
This is a quick and dirty way to get to the finish line. A better way would be to apply the same logic in Power Query or even bake in the whole logic just into a DAX measure but as I mentioned in the begining the solution depends on how your invoices are ordered.
Thanks,
N -
Your phrase "first 50 items" is the key to the sulution. Please clarify or as @ryan_mayu suggested please provide a data sample. Meanwhile, assuming your invoices are numeric and not alpha numeric then you can create a calculated coumn with a simple condition below (Mulitplier Column)
Multiplier = IF('Table'[Invoice #] >= 2050, 40, 50)
you can hardcode the condition value as I did in my case 2000+ 50 , or
create a use MIN() function to pull the min value and add 50
MIN('Table'[Invoice #])+50
Multiplier = IF('Table'[Invoice #] >= MIN('Table'[Invoice #])+50, 40, 50)
Multiplied Amount = 'Table'[Amount] * 'Table'[Multiplier]
This is a quick and dirty way to get to the finish line. A better way would be to apply the same logic in Power Query or even bake in the whole logic just into a DAX measure but as I mentioned in the begining the solution depends on how your invoices are ordered.
Thanks,
N -
Your suggestion worked, thanks! I'll keep in mind to send samples for more clarification next time
could you pls priovde the sample data and expected output?
Proud to be a Super User!
User | Count |
---|---|
141 | |
113 | |
104 | |
77 | |
64 |
User | Count |
---|---|
135 | |
123 | |
101 | |
71 | |
61 |