Forum Discussion

PBI_AMS's avatar
PBI_AMS
Helper I
2 years ago
Solved

Switch statement with condition?

I'm trying to add a column to a table for reporting in the service. I have two tables: 

Opportunity

Employee

 

The Employee table is connected to the Opportunity table in as many as 4 different places: Leader, Expert, Source, Team Member. Each of these can also be blank.  The "Leader" is the active connection.  I want to add a column that says: 

 

Is there a name in the Source field? If so, pull the name of the Department associated with the Source from the related Employee table. Otherwise leave it null. So I'm not sure how to tell Power Query to refer to the "Source" connection between the Employee and Opportunity tables. 

 

This is producing  null where it should be, but it's giving me an error where I want the "Source" Department: 

 

Table.AddColumn(#"Renamed columns 2", "Business Source", each if [Source] is null then null else RELATED[#"Employee(department)"])
I feel like I'm missing something like a switch statement? 
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi PBI_AMS ,

    Please try to use the following codes:

    Table.AddColumn(#"Renamed columns 2", "Business Source", each if [Source] is null then null else RELATEDTABLE(Employee)[department])

     

    How to Get Your Question Answered Quickly 

     

    If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

     

    Best Regards
    Community Support Team _ Rongtie

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

     

     

     

     

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi PBI_AMS ,

    Please try to use the following codes:

    Table.AddColumn(#"Renamed columns 2", "Business Source", each if [Source] is null then null else RELATEDTABLE(Employee)[department])

     

    How to Get Your Question Answered Quickly 

     

    If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

     

    Best Regards
    Community Support Team _ Rongtie

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