Sum 2 cells but if the cell is blank use another cell

[Anonymous]

Hello community!

I have some problems writing the correct DAX code. I have a table where the first column shows the parking price for the 1 hour(or 1 hour), the second column show the price for the second hour parked, and the third column shows the price for the third hour parked.

What I want to express is price for 2 hours of parking. Normaly the price is the first column + the second column, but when the second column is blank I want to multiple the first column by 2. How can I write this command in DAX?

[amitchandak · Accepted solution]

@Anonymous , Not very clear you need this in measure or column .

New column  = if(isblank([column2]), [Column1] *2, [Column1]  + [Column2] )

[Anonymous · Accepted solution]

Thank you, I also found this solution;

Measure = CALCULATE

(SUMX(Table,

IF(datastore_search[Timepris]+datastore_search[Timepris andre Time]>datastore_search[Timepris],datastore_search[Timepris]+datastore_search[Timepris andre Time],datastore_search[Timepris]*2) ))

[amitchandak · Accepted solution]

@Anonymous , Not very clear you need this in measure or column .

New column  = if(isblank([column2]), [Column1] *2, [Column1]  + [Column2] )