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 p...
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.

     

     

     

     

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.