Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi awesome ppl,
I am currently using visual filter which works but could anyone please suggest best way to get this output column?
Student ID | Type | Yearly pay | Output expecting | |
D00123 | Daily | Other | Daily | |
S00124 | Seasonal | Other | Seasonal | |
M00125 | Seasonal | Other | Seasonal | |
M00126 | Monthly | Yearly | Yearly | |
M00127 | Monthly | Other | Monthly | |
D00128 | Daily | Other | Daily | |
D00129 | Daily | Other | Daily | |
S00130 | Seasonal | Other | Seasonal | |
D00131 | Daily | Other | Daily | |
M00132 | Monthly | Yearly | Yearly | |
M00137 | Monthly | Other | Monthly | |
D = Daily | ||||
S = Seasonal | ||||
M = Monthly |
Thank you in advance
Van2050
Solved! Go to Solution.
If I am understanding the logic behind the expected outcome then:
Custom column via the Power Query Editor: if [Yearly pay] = "Yearly" then "Yearly" else [Type]
New Calculated column: Output = IF('Table'[Yearly pay] = "Yearly", "Yearly", 'Table'[Type])
If I am understanding the logic behind the expected outcome then:
Custom column via the Power Query Editor: if [Yearly pay] = "Yearly" then "Yearly" else [Type]
New Calculated column: Output = IF('Table'[Yearly pay] = "Yearly", "Yearly", 'Table'[Type])
Both work like a charm, Thank you so much for your help.
Have a great weekend!