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.

     

3 Replies

  • 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.

     

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    4 years ago

    Anonymous, format and if are wrongly placed. Also you are comparing text with int

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      amitchandak  Pls help rewrite the query.