connecting multiple values with one value

[Anonymous]

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

[v-juanli-msft]

Hi @Anonymous 

For example, data example as below:

Create a measure

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

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.

[Anonymous]

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

[edhans]

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