Forum Discussion

erhan_79's avatar
erhan_79
Icon for Post Prodigy rankPost Prodigy
6 years ago
Solved

Formula Help "IF Starts"

Dear All ;

 

i need you small help , i have a column in a table as below and i want to create a new column like that ;

 

if "material group" starts with "1" write to cell  "spare parts" , if not dont write anything just cell will be empty

 

 

 

 

 

Need Help
  • edhans's avatar
    edhans
    6 years ago

    Power BI DAX lets you use string functions with values.

     

    Column = 
if(
    LEFT('Table'[Column1],1) = "1",
    "Good",
    BLANK()
)

1 Reply

  • edhans's avatar
    edhans
    Icon for Community Champion rankCommunity Champion
    6 years ago

    Power BI DAX lets you use string functions with values.

     

    Column = 
if(
    LEFT('Table'[Column1],1) = "1",
    "Good",
    BLANK()
)