Forum Discussion
How do i set up DAX function
Hi,
how do i setup a dax formula that checks if value = Dropped in column B, then replace value "closed" in column A. If not, all values from column A should be transfered to column C.
| Colum A: | Column B: | Column C (wanted result): | |
| Closed | Dropped | Dropped | |
| In progress | Ongoing | In progress | |
| Monitor | Ongoing | Monitor | |
| Closed | Actual | Closed | |
| Closed | Implemented | Closed | |
| New | Ongoing | New |
BR Patirk
Anonymous Try:
Column C = IF([Column B] = "Dropped", "Dropped", [Column A])
1 Reply
Anonymous Try:
Column C = IF([Column B] = "Dropped", "Dropped", [Column A])