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,...
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

     

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

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

  • 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