Forum Discussion

vjnvinod's avatar
vjnvinod
Icon for Impactful Individual rankImpactful Individual
6 years ago
Solved

Custom coloumn support

hi,

 

below is my conditional coloumn(in power query), which is not giving me the right output

 

= Table.AddColumn(#"Filtered Rows", "Custom", each if [Actual USD Constant] < 0 then "Reverse Charge" else "Not a reverse")

 

what i need is

 custom or conditional coloumn based on below parameter, let me know how to create that

if [Actual USD Constant] <= 0  and c. Charged hours<0

then "Reverse Charge" else "Not a reverse")

 

 

Need Help
Show and Tell

2 Replies

  • vjnvinod's avatar
    vjnvinod
    Icon for Impactful Individual rankImpactful Individual
    6 years ago

    hi All,

     

    i figured it out, thanks

    • dax's avatar
      dax
      Icon for Community Support rankCommunity Support
      6 years ago

      Hi vjnvinod, 

      It seems that you solve this problem, right? If so and if you'd like to, you could mark corresponding post as answer or share your solutions. That way, people who in this forum and have similar issue will benefit from it.

      Best Regards,
      Zoe Zhi

      If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.