Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
crobinson661
Frequent Visitor

Help with Lookup/Return/Visual

I have two tables: Time and Item


table.Time is the amount of [Days] associated with a [Step] based on cost identified in a range (Fields for [Cost Min]/[Cost Max])

table.Item is a list of [Item]s with it's current [Cost] and [Step]. 

 

I need to return the current and future [Step]s and their respective [Days] from table.Time within a cost group ([Cost Min]/[Cost Max]) based on the [Cost] and [Step] of the item selected in table.Item. The [Step]s I need to return are the selected one, and all that come after in that group (potentially determined by [UN] range? (unique identifier for table.Time)

 

table.Time:  

Time
UN Cost MinCost Max      StepDays
1010Step 1            4
2010Step 23
3010Step 32
4010Step 41
51120Step 18
61120Step 27
71120Step 36
81120Step 45
92130Step 112
102130Step 211
112130Step 310
122130Step 49


table.Item

Item
ItemCostStep
A10Step 1
B12Step 2
C30Step 4


Examples of returns when specific items are selected in table.Item:

Return When Item A Selected
Step 14
Step 23
Step 32
Step 41
  
Return When Item B Selected
Step 27
Step 36
Step 45
  
  
Return When Item C Selected
Step 49


Ultimately, in the exmaples above, [Days] needs to be a date in the future calculated off TODAY() adding the number in [Days]. I  also am not sure the best visual to return this to.


Edit*** I realized my initial presentation with colors in place of [Step]s was unclear so I changed the data to explain better. 

1 REPLY 1
ryan_mayu
Super User
Super User

why select B and C only see three and one color? there are 4 colors in the first table.





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.

Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

Top Kudoed Authors