Solved: Re: DAX QUERY

Anonymous · ‎06-23-2022

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 · ‎06-27-2022

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.

How to get your questions answered quickly -- How to provide sample data

View solution in original post

v-yalanwu-msft · ‎06-27-2022

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.

How to get your questions answered quickly -- How to provide sample data

amitchandak · ‎06-23-2022

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

!! Power BI 101 Interview questions !! !! Master Microsoft Fabric- 36 Videos !!
Microsoft Power BI Learning Resources, 2023 !!
Learn Power BI - Full Course with Dec-2022, with Window, Index, Offset, 100+ Topics !!
Did I answer your question? Mark my post as a solution! Appreciate your Kudos !! Proud to be a Super User! !!

Anonymous · ‎06-23-2022

@amitchandak Pls help rewrite the query.

DAX QUERY

Helpful resources

Microsoft Fabric & AI Learning Hackathon