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: 

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

Reply
ShajiFiroz
New Member

matching word from multiple columns

‎01-27-2021 09:30 PM

Am looking to get a DAX formula for the following scenario, 

If Stage = 1, and Artifact1 to Artifact4 columns = Released, then output Ready For Sale in the new coloum 

Capture.JPG

Looking for some answers, thank you

Labels:
Message 1 of 3
673 Views
0
1 ACCEPTED SOLUTION
AnkitKukreja
Super User
Super User

‎01-27-2021 11:22 PM

Hi @ShajiFiroz 

 

I hope I have understood your requirement correctly, please use the below dax as a calculated column and you're good to go.

Launch Progress =
    IF( 'Table'[Stage] = 1 && 'Table'[Artifact1] = "Released" &&
'Table'[Artifact2] = "Released" && 'Table'[Artifact3] = "Released" &&
        'Table'[Artifact4] = "Released" , "Ready for Sale" , "Not Ready" )
 
CommunitySolution.JPG

 

For Power BI trainings or support dm or reach out to me on LinkedIn.
If my response has successfully addressed your question or concern, I kindly request that you mark this post as resolved. Additionally, if you found my assistance helpful, a thumbs-up would be greatly appreciated.

Thanks,
Ankit Kukreja
www.linkedin.com/in/ankit-kukreja1904

View solution in original post

Message 2 of 3
639 Views
2 REPLIES 2
AnkitKukreja
Super User
Super User

‎01-27-2021 11:22 PM

Hi @ShajiFiroz 

 

I hope I have understood your requirement correctly, please use the below dax as a calculated column and you're good to go.

Launch Progress =
    IF( 'Table'[Stage] = 1 && 'Table'[Artifact1] = "Released" &&
'Table'[Artifact2] = "Released" && 'Table'[Artifact3] = "Released" &&
        'Table'[Artifact4] = "Released" , "Ready for Sale" , "Not Ready" )
 
CommunitySolution.JPG

 

For Power BI trainings or support dm or reach out to me on LinkedIn.
If my response has successfully addressed your question or concern, I kindly request that you mark this post as resolved. Additionally, if you found my assistance helpful, a thumbs-up would be greatly appreciated.

Thanks,
Ankit Kukreja
www.linkedin.com/in/ankit-kukreja1904
Message 2 of 3
640 Views
ShajiFiroz
New Member
In response to AnkitKukreja

‎01-28-2021 01:26 AM

Thanks Ankit
It worked!

Message 3 of 3
632 Views

Helpful resources

Announcements
November Power BI Update Carousel

Power BI Monthly Update - November 2025

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

Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

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