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

Eduardo_Suela's avatar
Eduardo_Suela
Helper I
2 years ago

Do you need it to be done in DAX?

If so. First you need to understand the difference between new column and new measure.

 

Do you have data already loaded in the data model?

You need data to do that operation.

If you have data, you can do your new colum / measure with normal algebra. Maybe you will need treatment of blanks.

 

If you dont need the calculation to be done in DAX, you can also have your multiplication done in Power Query before data are loaded.

 

Hope it helps