Home Forums Power Pivot Search across multiple columns in a row for a specific value

This topic contains 0 replies, has 1 voice, and was last updated by  epeck78 4 months ago.

Viewing 1 post (of 1 total)
  • Author
    Posts
  • #8212

    epeck78
    Participant
    • Started: 1
    • Replies: 0
    • Total: 1

    I am using PowerQuery to break out multiple values in a column into separate columns (Area1, Area2, Area3). I need of a DAX search formula to review the 3 new columns (Area1, Area2, Area3) to determine if CAT1, CAT2, etc is present and place a 1 in the corresponding column if present.

    Note – The category’s will never show up in multiple columns in a single row. Example, if CAT1 shows up in “Area1” it will never show up in “Area2” or Area3” in that row.

    Thank you in advance!

    Attachments:
    You must be logged in to view attached files.
Viewing 1 post (of 1 total)

You must be logged in to reply to this topic.