Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

if when column in power query

Hi all,   I am struggling to get a if when statement to work as a calculated column in power query. the logic I am trying to create is:   if [sales] > 0 where [region] = AMER and [returns] < 1 ...
Need Help
Show and Tell
Tips and Tricks
  • V-lianl-msft's avatar
    V-lianl-msft
    4 years ago

    Hi Anonymous ,

     

    Try to create a custom column with Power query:

    if [Region]= "a" and [Returns] <1 and [Sales]>0 and List.Contains({1,2,3},[Type])
then 1 else ""

     


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

rajkmr106's avatar
rajkmr106
New Member
4 years ago

This is defently  possible in power query, You need to filter the value based on required value and also need to mentioned the condition for it.

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    rajkmr106  what would the correct logic look like? 

    if [sales] > 0

    filter [region] = AMER

    and [returns] < 1 filter [type] IN 1,2,3,4,5

    Then 1 else " " ?