Hi,
I have a dataset with 3 columns, Transaction_ID, Pot_1 and Pot_2. I want to create a new column called Decision.
The rule is if not all Pot_1 is NA within the same Transaction_ID, then extract Pot_1 value to Decision column, otherwise Pot_2 will be in Decision column.
The conditional column in Power Query Edition is unable to capture by the same column value (using Transaction_ID).
Please advise how use DAX to create the new Decision column. Thanks.
