Forum Discussion
Lookup column for filtered data
Hello everyone,
I have 2 tables in Power BI.
However when I created 2 reports (from the 2 separate tables), I would like to look up from a list of filtered data and fill in the other table:
Hi sophtee,
This piece of code should help you:
In plain text:
Age1 = VAR currentFlock = [Flock1] RETURN MAXX ( FILTER ( T2, [Flk#] = currentFlock ), [Ageflk] )Best Regards,
Alexander
Hi, sophtee
Based on your description, I have created some measures to achieve the effect you are looking for. Following picture shows the effect of the display.
Measure:
Age1 = LOOKUPVALUE ( Table2[Agefilk], Table2[Flk#], Table1[Flock1] )
Best Regards,
Yang
Community Support TeamIf there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!How to get your questions answered quickly -- How to provide sample data in the Power BI Forum
2 Replies
Hi sophtee,
This piece of code should help you:
In plain text:
Age1 = VAR currentFlock = [Flock1] RETURN MAXX ( FILTER ( T2, [Flk#] = currentFlock ), [Ageflk] )Best Regards,
Alexander
Hi, sophtee
Based on your description, I have created some measures to achieve the effect you are looking for. Following picture shows the effect of the display.
Measure:
Age1 = LOOKUPVALUE ( Table2[Agefilk], Table2[Flk#], Table1[Flock1] )
Best Regards,
Yang
Community Support TeamIf there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!How to get your questions answered quickly -- How to provide sample data in the Power BI Forum