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 VI
Super User VI

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 Community Highlights

Check out a full recap of the month!

August 2020 CYST Challenge

Check out the winners of the recent 'Can You Solve These?' community challenge!

Experience what’s next for Power BI

Join us for an in-depth look at the new Power BI features and capabilities at the free Microsoft Business Applications Launch Event.