Forum Discussion

erhodes's avatar
erhodes
Advocate II
9 years ago

What If analysis to adjust date values?

I'm wanting to use the new What If peramter functionality in a report to allow users to adjust dates. The use case is for a sales pipeline. We currently have defined est. close dates from CRM. The Wh...
Need Help
v-jiascu-msft's avatar
v-jiascu-msft
Microsoft Employee
9 years ago

Hi erhodes,

 

Can you post a dummy sample here in text mode? Maybe we can try this.

a =
CALCULATE (
    SUM ( [contract value] ),
    FILTER ( datetable, datetable <= MAX ( [est. close date] ) + [what if value] )
)

Best Regards!

Dale

mcharing's avatar
mcharing
Frequent Visitor
8 years ago

Hi,

 

In your measure you use a FILTER which implies row context; in Filter you are relating to a datetable (I assume their is one) and compare this to the "est. close date" from the fact table. How does this work? Isn't it needed to use RELATED since where in row context their?