undefined

[Vkt]

Thanks in advance.

I have two fields expected date and requested date in a fact table.

I have created a measure like this:

If (expected date<> blank && expected date < requested date, quantity, blank)

Quantity is measure which already created

Unfortunately its not working as measure in my power bi.

It's giving an error : a table of multiple value was supplied

Any alternative to create this above condition as measure.

Regards,

[Vkt]

@TomMartens Thanks for your response.

If (expected date<> blank && expected date < requested date, quantity, blank)

The above expression is a dax measure but in my scenario I can't use aggregation.

[TomMartens]

Hey @Vkt ,

what you posted is not a measure, at best it's pseudo code.
If you can't use an aggregation function, then you have to use a table iterator function like MAXX, or SUMX. Table iterator functions create a row context, this allows to reference a column w/o using an aggregation function.

Regards,

Tom

[TomMartens]

Hey @Vkt ,

share the exact DAX code of your measure.
Whenever you are creating a measure you have to wrap a column reference inside an aggregation function like MAX('<your table name>'[the column name]). It also can become possible to wrap the aggregation function inside a CALCULATE( ... ) to modify the current filter context.

If you are new to measures, start here: https://learn.microsoft.com/en-us/power-bi/transform-model/desktop-tutorial-create-measures?WT.mc_id...

Hopefully, this provides some additional insights to tackle your challenge.

Regards,

Tom