Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes! Register now.

Reply
Anonymous
Not applicable

DAX QUERY

‎06-23-2022 04:33 PM

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

 

 

Olivia25_0-1656027603152.png

 

Message 1 of 4
1,932 Views
0
1 ACCEPTED SOLUTION
v-yalanwu-msft
Community Support
Community Support

‎06-27-2022 11:16 PM

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

Message 4 of 4
1,826 Views
3 REPLIES 3
v-yalanwu-msft
Community Support
Community Support

‎06-27-2022 11:16 PM

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
Message 4 of 4
1,827 Views
amitchandak
Super User
Super User

‎06-23-2022 07:15 PM

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

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube
Message 2 of 4
1,872 Views
0
Anonymous
Not applicable
In response to amitchandak

‎06-23-2022 07:44 PM

@amitchandak  Pls help rewrite the query. 

Message 3 of 4
1,867 Views
0

Helpful resources

Announcements
September Power BI Update Carousel

Power BI Monthly Update - September 2025

Check out the September 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

View All