topic DAX QUERY in DAX Commands and Tips

DAX QUERY

Anonymous — Fri, 24 Jun 2022 00:48:42 GMT

Hi All
Please can anyone help me rewrite this below query as a column. want to see Late or On time as a row.

Re: DAX QUERY

amitchandak — Fri, 24 Jun 2022 02:15:36 GMT

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

Re: DAX QUERY

Anonymous — Fri, 24 Jun 2022 02:44:01 GMT

amitchandak Pls help rewrite the query.

Re: DAX QUERY

v-yalanwu-msft — Tue, 28 Jun 2022 06:16:15 GMT

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.