Hai
Can we add column in power query data and add formula. I want to add column add new formula, if the d/c is C, the amount should be negative sign (-) , if not is as per dataa
Example,
<tbody>
</tbody>
Can we add column in power query data and add formula. I want to add column add new formula, if the d/c is C, the amount should be negative sign (-) , if not is as per dataa
Example,
Amount | D/C | Add Column - New Column with formula | |
50 | C | -50 | |
50 | D | 50 | |
100 | C | -100 |
<tbody>
</tbody>