Forum Discussion
Condition formula to return a value from a different column
Memorable MemberHi leecity215,
If you're trying to add a calculated column to TableA, try:
ME Hours =
VAR Filtered =
FILTER (
TableB,
TableB[Max Integrations] >= TableA[Count]
)
VAR Result =
MINX (
Filtered,
TableB[ME Hours]
)
RETURN Result
----------------------------------
If this post helps, please consider accepting it as the solution to help other members find it quickly. Also, don't forget to hit that thumbs up and subscribe! (Oh, uh, wrong platform?)
P.S. Need a more in-depth consultation for your Power BI data modeling or DAX issues? Feel free to hire me on Upwork or DM me directly on here! I would love to clear up your Power BI headaches.
Hi there, this worked really well. The only issue is that it only returned a result for one row of data, the first row? Could it be because in table B in my model i am just showing the year whereas in table i am showing a long dat format dd/mm/yyyy? Thank you very much for your help.
- Wilson_
leecity,
Can you please share a sample pbix file? (If you don't know how, please check the pinned thread in the forum.) It would make debugging your issue easier. 🙂
Wilson_ Thanks for your contribution on this thread.
Hi leecity215 ,
It will return the expected result after creating the calculated column in table A which provide by Wilson_ , please check the below screenshot. What do you mean that it only returned a result for one row of data, the first row? Could you please provide more sample data and expected result with the logic and specific examples? It is better if you can provide the sample pbix file(exclude the sensitive info) just as suggested by Wilson_ . Thank you.
How to upload PBI in Community
Best Regards