topic Multiple conditions for price round in DAX Commands and Tips

Multiple conditions for price round

Jadreani — Mon, 09 May 2022 15:31:30 GMT

Hello,

I'd like to find a solution in DAX to create multiple condition to round the prices of a column depending a range of price.

For example:

Thanks so much for your kind help.

Jean-Yves

speedramps — Mon, 09 May 2022 21:00:38 GMT

Hu Jean-Yus

Your answer =

VAR myvalue = SELECTVALUE(youtable[yourcolumn])
RETURN

SWITCH(TRUE(),
// 0-1 ROUND(1) (to the decimal)
myvalue <= 1, ROUND(myvalue,1),

// >1-10 ROUND(0) (to the unit)
myvalue <= 10, ROUND(myvalue,0),

// >10-100 ROUND(0) (to the unit)
myvalue <= 100, ROUND(myvalue,0),

// >100-1000 MROUND(5)
myvalue <= 1000, ROUND((myvalue,5),

// >1000-10'000 MROUND(50)
myvalue <= 10000, ROUND((myvalue,50),

// >10'000-100'000 MROUND(100)
myvalue <= 100000, ROUND((myvalue,100),

// >100'000-1'000'000 MROUND(1000)
myvalue <= 1000000, ROUND((myvalue,1000),

myvalue

)

Please click thumbs up and accept as solution. Thank you.

You could impove performance by removing >1-10 became it is the same as >10-100 ROUND(0).

Alsonote values over 1000000, will not be rounded

speedramps — Mon, 16 May 2022 18:17:32 GMT

I helped you quickly, so please help me with kudos.

Please click the thumbs up and acccept solution buttons. Thank you ! 😎