cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted

connecting multiple values with one value

Hi girls & guys,

 

once again I need your help.

I have following issue.

- two tables which are connected via the item#. N-->1

- table #1 has multiple shelflife values for some items, hence sometimes mutliple item#rows. (N)

- table #2 is a itemcharacteristic table, hence 1 row per item# (1)

- I build a max and min value DAX these shelflife values since i am only interested in the extemes.

- i want to create 2 colums in my characteristic table in order being able to filter by these shelflifedates on an item#level.

 

how can i extract those values and implment them. 

I need something Like: 

IF(itemID [table1] = itemID [table2]; shelflifedays(max); 0)

the idea is that if the item# match the value from table#1 is displayed in my new column in table2. 

 

Thanks in advance.

 

BR,

 

Paul

3 REPLIES 3
Highlighted
Super User II
Super User II

Re: connecting multiple values with one value

It would be helpful if you posted some data, and also clarify. You posted this in the Power Query forum, but you are using DAX language. I think Power Query is were this goes honestly, but without data to play with it is hard to fully undertand and impossible to show you a code example.

 

How to get good help fast. Help us help you.
How to Get Your Question Answered Quickly
How to provide sample data in the Power BI Forum



Did I answer your question? Mark my post as a solution!
Did my answers help arrive at a solution? Give it a kudos by clicking the Thumbs Up!

DAX is for Analysis. Power Query is for Data Modeling


Proud to be a Super User!

MCSA: BI Reporting
Highlighted
Community Support
Community Support

Re: connecting multiple values with one value

Hi @Bademeister1337 

For example, data example as below:

Capture14.JPG

Create a measure

Measure = CALCULATE(MAX(Table2[shelflifedays]),FILTER(ALLSELECTED(Table2),Table2[item]=MAX(Table2[item])))

Capture15.JPG

Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Highlighted

Re: connecting multiple values with one value

Hello Maggie,

 

your result is exactly what i was looking for but for a column. 

Unfortunately if i aplly this to a column i reveive only one value for each row. 

Is there a way to apply a this mechanism in order to get a colum with these values?

 

BR,

Paul

Helpful resources

Announcements
August 2020 Community Challenge: Can You Solve These?

August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

Community Blog

Community Blog

Visit our Community Blog for articles, guides, and information created by fellow community members.

Upcoming Events

Upcoming Events

Wondering what events you could join or have an event to promote yourself? Check out our Upcoming Events.

Community Summit Australia – Join Online!

Community Summit Australia – Join Online!

Be a part of the leading Microsoft Business Applications digital event, curated for the APAC community.

Top Solution Authors
Top Kudoed Authors