Forum Discussion

st-dat's avatar
st-dat
Helper III
7 years ago
Solved

Calculated column from four other column

Hi,   I need help to create a calculated field STATUS from other four columns such as JOB-TYPE, ID-NO, DEPT-ID and STAFF-ID. Mandatory Conditions that must be met to have "Fulltime" as data under ...
Need Help
  • v-chuncz-msft's avatar
    v-chuncz-msft
    7 years ago

    st-dat,

     

    You may refer to the following DAX.

    Column =
IF (
    Table1[JOB-TYPE] = "Regular"
        && Table1[ID-NO] = "XXXX"
        && SEARCH ( "T", Table1[DEPT-ID],, 0 ) > 0
        && SEARCH ( "258", Table1[STAFF-ID],, 0 ) > 0
        && SEARCH ( "2580", Table1[STAFF-ID],, 0 ) = 0,
    "Fulltime"
)
v-chuncz-msft's avatar
v-chuncz-msft
Community Support
7 years ago

st-dat,

 

You may refer to the following DAX.

Column =
IF (
    Table1[JOB-TYPE] = "Regular"
        && Table1[ID-NO] = "XXXX"
        && SEARCH ( "T", Table1[DEPT-ID],, 0 ) > 0
        && SEARCH ( "258", Table1[STAFF-ID],, 0 ) > 0
        && SEARCH ( "2580", Table1[STAFF-ID],, 0 ) = 0,
    "Fulltime"
)
  • st-dat's avatar
    st-dat
    Helper III
    7 years ago

    Hi Sam,

     

    Thank you for your help, I will update you on the outcome tomorrow.

     

    Esteemed Regards

  • st-dat's avatar
    st-dat
    Helper III
    7 years ago

    Hi Sam,

     

    The solution works for me excellently.

     

    Thank you so much.