Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

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 Sta...
Need Help
  • smpa01's avatar
    smpa01
    4 years ago

    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]))
smpa01's avatar
smpa01
Community Champion
4 years ago

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