Forum Discussion

dfricker's avatar
dfricker
New Member
6 years ago
Solved

Populate Conditional Column by Common ID

Hi All,   I am new to Power BI, and I am stuck on the best way to solve an issue. The requirement is to populate multiple columns based multiple criteria from multi-rowed data. I was able to get th...
  • Anonymous's avatar
    Anonymous
    6 years ago

    Hi,

    Is it ok to have a calculated column instead of using Power Query (since this is in the DAX forum)? Perhaps this can work?

    Success =
VAR _rowId = 'Table'[ID]
RETURN
    IF (
        CONTAINS ( ALL ( 'Table' ); 'Table'[ID]; _rowId; 'Table'[Criteria 1]; "Meets" )
            || CONTAINS ( ALL ( 'Table' ); 'Table'[ID]; _rowId; 'Table'[Criteria 2]; "Meets" );
        "Yes";
        "No"
    )

     

    Best Regards // Ulf 

Anonymous's avatar
Anonymous
Not applicable
6 years ago
As you rightly say - this is a job for Power Query, not DAX. Please ask this question on a Power Query forum.

Best
D