Multiple conditions for price round

Question

Hello,&nbsp;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.&nbsp;For example:Price rangeRound Formula0-1ROUND(1) (to the decimal)&gt;1-10ROUND(0) (to the unit)&gt;10-100ROUND(0) (to the unit)&gt;100-1000MROUND(5)&gt;1000-10'000MROUND(50)&gt;10'000-100'000MROUND(100)&gt;100'000-1'000'000MROUND(1000)&nbsp;Thanks so much for your kind help.&nbsp;Jean-Yves

speedramps · Accepted Answer

Hu Jean-Yus
&nbsp;
Your answer =
VAR myvalue = SELECTVALUE(youtable[yourcolumn])RETURN
SWITCH(TRUE(),// 0-1 ROUND(1) (to the decimal)myvalue &lt;= 1, ROUND(myvalue,1),
// &gt;1-10 ROUND(0) (to the unit)myvalue &lt;= 10, ROUND(myvalue,0),
// &gt;10-100 ROUND(0) (to the unit)myvalue &lt;= 100, ROUND(myvalue,0),
// &gt;100-1000 MROUND(5)myvalue &lt;= 1000, ROUND((myvalue,5),
// &gt;1000-10'000 MROUND(50)myvalue &lt;= 10000, ROUND((myvalue,50),
// &gt;10'000-100'000 MROUND(100)myvalue &lt;= 100000, ROUND((myvalue,100),
// &gt;100'000-1'000'000 MROUND(1000)myvalue &lt;= 1000000, ROUND((myvalue,1000),
myvalue
)
&nbsp;
Please click thumbs up and accept as solution. Thank you.
You could impove performance by removing&nbsp;&gt;1-10 became it is the same as&nbsp;&gt;10-100 ROUND(0).
Alsonote&nbsp; values over&nbsp;1000000, will not be rounded
&nbsp;
&nbsp;

Forum Discussion

Multiple conditions for price round

2 Replies

Related content

Multiple conditions Index

Multiple Donut charts with conditions

Conditional Column with Multiple Conditions

PBIRS Deployment Pricing

Reserved Fabric Pricing

Price range	Round Formula
0-1	ROUND(1) (to the decimal)
>1-10	ROUND(0) (to the unit)
>10-100	ROUND(0) (to the unit)
>100-1000	MROUND(5)
>1000-10'000	MROUND(50)
>10'000-100'000	MROUND(100)
>100'000-1'000'000	MROUND(1000)