DAX expression help

Question

Hi,I am trying to generate a new column based on two other columns, and not able to get this to work.&nbsp;Item1&nbsp; &nbsp; &nbsp;1/1/21&nbsp; &nbsp; &nbsp;8Item1&nbsp; &nbsp; &nbsp; 1/1/21&nbsp; &nbsp; 8Item1&nbsp; &nbsp; &nbsp; 1/1/21&nbsp; &nbsp; 8Item1&nbsp; &nbsp; &nbsp;1/2/21&nbsp; &nbsp; &nbsp;9Item1&nbsp; &nbsp; &nbsp; 1/2/21&nbsp; &nbsp; 9Item2&nbsp; &nbsp; &nbsp;1/1/21&nbsp; &nbsp; &nbsp;10Item2&nbsp; &nbsp; &nbsp; 1/1/21&nbsp; &nbsp; 10Item2&nbsp; &nbsp; &nbsp;1/2/21&nbsp; &nbsp; &nbsp;8Item2&nbsp; &nbsp; &nbsp; 1/2/21&nbsp; &nbsp; 8&nbsp;&nbsp;Desired Output:Item1&nbsp; &nbsp; &nbsp;1/1/21&nbsp; &nbsp; &nbsp;8Item1&nbsp; &nbsp; &nbsp; 1/1/21&nbsp; &nbsp; 0Item1&nbsp; &nbsp; &nbsp; 1/1/21&nbsp; &nbsp; 0Item1&nbsp; &nbsp; &nbsp;1/2/21&nbsp; &nbsp; &nbsp;9Item1&nbsp; &nbsp; &nbsp; 1/2/21&nbsp; &nbsp; 0Item2&nbsp; &nbsp; &nbsp;1/1/21&nbsp; &nbsp; &nbsp;10Item2&nbsp; &nbsp; &nbsp; 1/1/21&nbsp; &nbsp; 0Item2&nbsp; &nbsp; &nbsp;1/2/21&nbsp; &nbsp; &nbsp;8Item2&nbsp; &nbsp; &nbsp; 1/2/21&nbsp; &nbsp; 0&nbsp;Basically, a new column should show the average of the number per item per date in one column and the other columns as 0 for the remaining rows for the same item and date.&nbsp;Hope my question is not confusing.

amitchandak · Accepted Answer

BB9 , first you need to add an index in the power query. 
&nbsp;
Then a new column
new column = var _min = minx(filter(Table, [item] = earlier([item]) &amp;&amp; [date] = earlier([date])),[Index])var _avg = minx(filter(Table, [item] = earlier([item]) &amp;&amp; [date] = earlier([date])),[value])return if([Index] =_min, _avg, blank())

Forum Discussion

DAX expression help

2 Replies

Related content

Weighed Average DAX Expression

DAX expression. HELP

dax expression help needed

Dax Expression

Help!!! Expression Error