Forum Discussion
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 will be 7
thanks in advance for your supports
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() )
5 Replies
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() )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
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....
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
