Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Giada90
Helper III
Helper III

m and dax formula

Hi,

I need to put a formula in both m and dax language that if a field starts with * I should create a column with "open", if it doesn't start with * I should have "closed", how can I do?

Thanks

fieldcolumn to create
*abcdopen
abcdclosed
  
  

 

1 ACCEPTED SOLUTION
DOLEARY85
Super User
Super User

Hi,

 

in power query you can create a custom column with the formula: 

 

if Text.StartsWith([Column1],"*") then "Open" else "Closed"

 

full m code: 

 

#"Added Custom" = Table.AddColumn(#"Changed Type", "Custom", each if Text.StartsWith([Column1],"*") then "Open" else "Closed")

 

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍


View solution in original post

3 REPLIES 3
DOLEARY85
Super User
Super User

Hi,

 

in power query you can create a custom column with the formula: 

 

if Text.StartsWith([Column1],"*") then "Open" else "Closed"

 

full m code: 

 

#"Added Custom" = Table.AddColumn(#"Changed Type", "Custom", each if Text.StartsWith([Column1],"*") then "Open" else "Closed")

 

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍


thanks!

Additionally in DAX calculated column:

 


Column = if(left('Table (13)'[Column1],1)="*","Open","Closed")
 
If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.