Returning a specific value across date in a table

Question

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??

lbendlin · Answer

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

ashish_mathur · Answer

Hi,
It will depend upon the structure of your data.&nbsp; Share the download link of the PBI file.

Forum Discussion

Returning a specific value across date in a table

2 Replies

Related content

Return "Specific value" from table 1, if not found, return value from table 2

Specific matrix

Using two conditions to return a specific value

Return only rows with max value from specific column

Measure returning incorrect value