Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Calculated Column Failure

Hello, I am trying to calculate whether a distributor of mine is on my program or not. This can be calculated by seeing if the "gwp_distributor_lookup" is blank. If it is, then the distributor is no...
Need Help
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi Anonymous ,

    Please refer to my pbix file to see if it helps you.

    Create a column.

    planned_distributor_check!! =
IF (
    ( 'Table'[gwp_distributor_llookup] ) = BLANK ()
        || 'Table'[Contributor] = BLANK (),
    "Planned For - Not on GWP",
    "Planned For - on GWP"
)

    If it does not help, please provide some sample data and your desired output (Preferably in picture form)

     

    Best Regards

    Community Support Team _ Polly

     

    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
4 years ago

Hi Anonymous ,

Please refer to my pbix file to see if it helps you.

Create a column.

planned_distributor_check!! =
IF (
    ( 'Table'[gwp_distributor_llookup] ) = BLANK ()
        || 'Table'[Contributor] = BLANK (),
    "Planned For - Not on GWP",
    "Planned For - on GWP"
)

If it does not help, please provide some sample data and your desired output (Preferably in picture form)

 

Best Regards

Community Support Team _ Polly

 

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
4 years ago

Thanks Polly!!! Works great