Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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 |
Solved! Go to Solution.
@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]))
@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]))
User | Count |
---|---|
103 | |
90 | |
78 | |
72 | |
68 |
User | Count |
---|---|
110 | |
96 | |
95 | |
74 | |
71 |