Returning a specific value across date in a table

[rcb0325]

Hello! I am trying to write a measure that will return the 'Sum of EstimatedQuantity' for each date. 

In the example, the date of 1/26/2023 is the only date that has an estimated quantity, but I am wanting to return the 67.7v7 value for each date that is shown for the selected production order. 

Is this possible?? 

[Ashish_Mathur]

Hi,

It will depend upon the structure of your data.  Share the download link of the PBI file.

[lbendlin]

you can do this easily in Power Query, and also (with some more effort) in DAX.  What have you tried and where are you stuck?