Forum Discussion

Saxon10's avatar
Saxon10
Post Prodigy
5 years ago
Solved

Calculated column contain multiple result

  I have two tables are, Data and report, In data table contain item and supplier and report table contain item.   Both tables the item column is unique.   Data Table:   ITEM SUPPLIER ...
Need Help
  • parry2k's avatar
    parry2k
    5 years ago

    Saxon10 add a new column in reporting table using the following expression, assuming these tables have a relation on Items  column

     

    Supplier = 
VAR __supplier = CALCULATE ( MAX ( 'DataTable'[SUPPLIER] ),  RELATEDTABLE ( 'DataTable' ) )
RETURN
COALESCE ( __supplier, "NA" )

     

    Check my latest blog post Compare Budgeted Scenarios vs. Actuals I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

    ⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡

  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi Saxon10 ,

    Based on your description, you can create a column as follows.

    Column = LOOKUPVALUE(Data[SUPPLIER],Data[ITEM],[ITEM],"NA")

    Result:

     

    Hope that's what you were looking for.

    Best Regards,

    Yuna

     

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

Hi Saxon10 ,

Based on your description, you can create a column as follows.

Column = LOOKUPVALUE(Data[SUPPLIER],Data[ITEM],[ITEM],"NA")

Result:

 

Hope that's what you were looking for.

Best Regards,

Yuna

 

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

 

 

  • Saxon10's avatar
    Saxon10
    Post Prodigy
    5 years ago

    Thanks for your reply and simple way of your solution.