Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

DAX QUERY

Hi All Please can anyone help me rewrite this below query as a column. want to see Late or On time as a row.       
  • v-yalanwu-msft's avatar
    v-yalanwu-msft
    4 years ago

    Hi, Anonymous ,

    Try it.

    _Question? =
IF (
    'Questionaire & App'[QuestionnaireStatusID] < 6
        && 'Questionaire & App'[QuestionnaireDeadline] > TODAY (),
    "Late",
    "On Time"
)


    Best Regards,
    Community Support Team _ Yalan Wu
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

v-yalanwu-msft's avatar
v-yalanwu-msft
Icon for Community Support rankCommunity Support
4 years ago

Hi, Anonymous ,

Try it.

_Question? =
IF (
    'Questionaire & App'[QuestionnaireStatusID] < 6
        && 'Questionaire & App'[QuestionnaireDeadline] > TODAY (),
    "Late",
    "On Time"
)


Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.