Forum Discussion

erhan_79's avatar
erhan_79
Post Prodigy
7 years ago
Solved

DAX formula help

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 

 

 

 

 

Need Help
  • AlB's avatar
    AlB
    7 years ago

    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

     

4 Replies

  • AlB's avatar
    AlB
    Community Champion
    7 years ago

    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's avatar
      AlB
      Community Champion
      7 years ago

      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's avatar
      erhan_79
      Post Prodigy
      7 years ago

      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