DAX formula help

[erhan_79]

Dear All ; 

i need your kind helps about below issue 

i have column A with numbers and i want to create a Column B as below : 

If Column A is 0 , Column B will 0 

İf column A is 1,2,3,4,5 , column B will be 5 

If column A is 6,7,8,9,10,11,12,13,14,15 , column B will be 15 

İf coumn A is 16 and ıncludes higher number , column B will be 30 

also i want like  that for minus situation too , 

i added below image to make more clear 

thanks for your kind supports 

[AlB]

Hi @erhan_79

Try this:

Table1[ColumnB] = SWITCH(TRUE(),
          Table1[ColumnA]=0, 0,
          Table1[ColumnA]>=1 && Table1[ColumnA]<=5, 5,
          Table1[ColumnA]>=6 && Table1[ColumnA]<=15, 15,
          Table1[ColumnA]>=16, 30,
          Table1[ColumnA]<=-1 && Table1[ColumnA]>=-5, -5,
          Table1[ColumnA]<=-6 && Table1[ColumnA]>=-15, -15,
          Table1[ColumnA]<=-16, -30)

[AlB · Accepted solution]

Hi @erhan_79

Change "ColumnA" for the exact name of your column. Seems to be "Column A"

Change "Table1" for the exact name of your table

Just use "Column B" instead of Table1[ColumnB] when creating the new column

[erhan_79]

thank you so much @AlB , great job , it is working.

[erhan_79]

Dear  @AlB;

thanks for your support but i got an error while creating column, i am new on power bI , could you pls share Pbix file ifit is possible that you created