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.
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!
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 |
---|---|
105 | |
97 | |
75 | |
63 | |
62 |
User | Count |
---|---|
137 | |
105 | |
104 | |
80 | |
63 |