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"
)
PattemManohar's avatar
PattemManohar
Community Champion
7 years ago
st-dat Did you tried the "Conditional Column" option in "Power Query".
It will be a straight forward solution there.... Please try...

Or Are you very particular to solve this in DAX ?
st-dat's avatar
st-dat
Helper III
7 years ago

Thanks a lot