Forum Discussion
Netope
Helper I
Helper IInject date selection from a dropdown slicer into a dax formula
Hi I am trying to create a measure that sums Totals for all contracts with EndDate >= the Year/month selected in a slicer dropdown. See PBI File with additonal explanations. https://drive.goo...
Hi Netope ,
You need to create an unrelated dimension table, for which you can view the following results:
Table = SUMMARIZE('Selected Value',[EndDate]) Total = var _s = SELECTEDVALUE('Table'[EndDate]) RETURN CALCULATE(SUM('Selected Value'[Act]),FILTER('Selected Value',[EndDate]>=_s))An attachment for your reference. Hope it helps!
Best regards,
Community Support Team_ Scott ChangIf this post helps then please consider Accept it as the solution to help the other members find it more quickly.
Thanks! it worked just fine
Hi Netope ,
You need to create an unrelated dimension table, for which you can view the following results:
Table = SUMMARIZE('Selected Value',[EndDate])
Total = var _s = SELECTEDVALUE('Table'[EndDate])
RETURN CALCULATE(SUM('Selected Value'[Act]),FILTER('Selected Value',[EndDate]>=_s))
An attachment for your reference. Hope it helps!
Best regards,
Community Support Team_ Scott Chang
If this post helps then please consider Accept it as the solution to help the other members find it more quickly.
NetopeHelper I
Helper IThanks! it worked just fine