Forum Discussion
undefined
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, bl...
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=DP-MVP-5003068
Hopefully, this provides some additional insights to tackle your challenge.
Regards,
Tom