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