Forum Discussion

erhan_79's avatar
erhan_79
Post Prodigy
7 years ago
Solved

Dax Formula Help

Dear All ;   i need your supports about creating a columnB   İ have ColumnA  ;   When ColumnA is A ; Column B will be 10 When ColumnA is B ; Column B will be 5 When ColumnA is C ; Column B wi...
Need Help
  • themistoklis's avatar
    themistoklis
    7 years ago

    erhan_79

     

    2 Options:

     

    Column B = IF (COLUMNA= "A", 10, IF (COLUMNA= "B", 5, IF (COLUMNA= "C", 7, BLANK())))

     

    Column B =
SWITCH (
    TRUE (),
    'Table'[Column A] = "A" , 10,
    'Table'[Column A] = "B" , 5,
    'Table'[Column A] = "C" , 7,
    BLANK()
)

     

v-yulgu-msft's avatar
v-yulgu-msft
Microsoft Employee
7 years ago

Hi erhan_79,

 

This looks like an odd behavior. Please click the "refresh" button on the top ribbon to see if it works. Re-load the data table and re-create the calculated Column B for a test.

 

Regards,

Yuliana Gu

  • erhan_79's avatar
    erhan_79
    Post Prodigy
    7 years ago

    dear v-yulgu-msft ;

     

    as you remind , i tried it and noe it is working thanks for your supports