Need to set up a calculation for price planning with two different values

[Amazing_Random]

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? 

[nickchobotar · Accepted solution]

@Amazing_Random 

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)

Then you can multiply mulitplier column  by amount =  

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 -

[Amazing_Random]

Your suggestion worked, thanks! I'll keep in mind to send samples for more clarification next time

[ryan_mayu]

could you pls priovde the sample data and expected output?