Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Create a calculated column using another calculated column

Hi,   I'm confronting a problem that I'm not able to solve. I request your help on this.    I created a column by using the formula Impact_Mean= calculate(SUM(Append1[Total Impact])/SUM(Append1[...
General Comment
Interesting Links
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • Samarth_18's avatar
    Samarth_18
    4 years ago

    Hi Anonymous ,

     

    Could you please try below code:-

    TEST =
SWITCH (
    TRUE (),
    TRUNC ( Append1[Impact_Mean] ) = 4
        && TRUNC ( Append1[Probability_Mean] ) = 4, "4",
    TRUNC ( Append1[Impact_Mean] ) = 4
        && TRUNC ( Append1[Probability_Mean] ) = 3, "1",
    TRUNC ( Append1[Impact_Mean] ) = 5
        && TRUNC ( Append1[Probability_Mean] ) = 5, "2",
    "0"
)

    BR,

    Samarth

     

SpartaBI's avatar
SpartaBI
Community Champion
4 years ago

Anonymous can you share a screenshot of the table with these calculated columns and their result.