Calculated Column If Statement

[Route111]

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

[smpa01 · Accepted solution]

@Route111 

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]))