Dax calculation

[Fali324]

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 multiply that number by 10 and give the output. 

e.g.

Number of floors is 10, therefore the output of the new column would be 10 * 10 = 100

if the number of Floors is 0 then the output would be 0.

I can do this by using 2 customs columns but wanted to see if I could reduce it and use just one column.

Thank you in advance for your help.

[Anonymous · Accepted solution]

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]

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