Forum Discussion

adriancho_BI's avatar
adriancho_BI
Regular Visitor
2 years ago
Solved

Create Category

Hello! I'm looking for some advice, in creating categories, but I'm using a logic statement like this: IF [Content Category] = "Content" then "Content" ELSE [domain] END

Where "Content" it's a value in my column1 but [domain] it's a column2. If the value in column1 is "Content", then use "Content", but, if it's different from "Content", use the value in the [domain] column.

Thanks in advance for your help!

  • Hi, you may create a conditional column like below:

    CondCol =
    IF('Content'[Column1] = "Content",
        'Content'[Column1],
        'Content'[Column2]
    )
    If this resolves your problem then mark it as Solution, thanks!

2 Replies

  • Hi, you may create a conditional column like below:

    CondCol =
    IF('Content'[Column1] = "Content",
        'Content'[Column1],
        'Content'[Column2]
    )
    If this resolves your problem then mark it as Solution, thanks!
  • could you pls provide some sample data and expected  output