Forum Discussion
Calculated Column If Statement
Hi Experts
Need and if statement to do the following based on the flag column.... (see sample date)
if we have 1 in the flag column then in the new status column insert the text from Amended Status column otherwise Current Status value in New status column.
| ID | Current Status | Amended Status | Flag | New Status |
| 1 | New Business | |||
| 2 | New Business | Renewal | 1 | |
| 3 | Renewal | |||
| 4 | New Business | Renewal | 1 | |
| 5 | Renewal | |||
| 6 | New Business | Renewal | 1 | |
| 7 | Renewal | |||
| 8 | New Business | |||
| 9 | Renewal | New Business | 1 | |
| 10 | Renewal | New Business | 1 |
Anonymous
Column = IF('Table'[Flag]=1,'Table'[Amended Status],'Table'[Current Status]) Measure = IF(max('Table'[Flag])=1,max('Table'[Amended Status]),max('Table'[Current Status]))
1 Reply
Anonymous
Column = IF('Table'[Flag]=1,'Table'[Amended Status],'Table'[Current Status]) Measure = IF(max('Table'[Flag])=1,max('Table'[Amended Status]),max('Table'[Current Status]))