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()
)

     

erhan_79's avatar
erhan_79
Post Prodigy
7 years ago

dear themistoklis

 

thanks for your kind support  ; it seems work but i could not undersatnd that : after i created the column , cells seems empty but  when i come on the cell with mouse it shows with popup there is the value that i wanted , why it is like that , it is like there is value in the cell but not seem, also from filter i can filter too but again value is not seemed 

 

 

 

 

 

themistoklis's avatar
themistoklis
Community Champion
7 years ago

erhan_79

 

I find it very strange. This shouldnt be happeing.

 

Can you share the dataset with us? Maybe there is an extra space in the raw data....