DAX QUERY

[Olivia25]

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 · Accepted solution]

Hi, @Olivia25 ,

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]

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

[Olivia25]

@amitchandak  Pls help rewrite the query.