Forum Discussion

Fali324's avatar
Fali324
Helper II
2 years ago
Solved

Dax calculation

Hi,   I'm quite new to DAX and would appricate all your help.   I have a column "number of floors" and what I would like to do is create another column, Where if that column has a value init then...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi  Fali324 ,

     

    Sorry, it's not clear what you mean by "value init", do you mean whether the data contains "init"?

    Here are the steps you can follow：

    1. Create calculated column.

    Column =
IF(
    CONTAINSSTRING(
        'Table'[Text],"init")=TRUE(),
        [Value] * 10 ,0)

    2. Result:

    If the results don't meet your expectations, can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data. We can better understand the problem and help you.

     

    Best Regards,

    Liu Yang

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi  Fali324 ,

 

Sorry, it's not clear what you mean by "value init", do you mean whether the data contains "init"?

Here are the steps you can follow：

1. Create calculated column.

Column =
IF(
    CONTAINSSTRING(
        'Table'[Text],"init")=TRUE(),
        [Value] * 10 ,0)

2. Result:

If the results don't meet your expectations, can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data. We can better understand the problem and help you.

 

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly