Forum Discussion

CalClack's avatar
CalClack
Helper II
6 years ago
Solved

Substitute Value using If Then Else

I would like to a calculated column value from one table if condition is true, else use a column value from another table if false. For instance in the screen shot if Ithere is a value > 0.00, I'd li...
  • Anonymous's avatar
    Anonymous
    6 years ago
    Hi. First, there's no screenshot. Second, a calculated column like this should be created and calculated during the ETL phase, possibly in Power Query. Calculated columns are not compressed optimally when created with DAX.

    Best
    D
Anonymous's avatar
Anonymous
Not applicable
6 years ago
Hi. First, there's no screenshot. Second, a calculated column like this should be created and calculated during the ETL phase, possibly in Power Query. Calculated columns are not compressed optimally when created with DAX.

Best
D
CalClack's avatar
CalClack
Helper II
6 years ago

Thanks, I will take a look at the ETL phase of calculating.