Forum Discussion

SG2015's avatar
SG2015
Frequent Visitor
4 years ago

Pass visual-date-filter as parameter for measure based on different date-table

Hi all I hope you guys can help me out here…   How can I pass the date-value in the visual-filter as a parameter for the calculation of a time-series measure that is based on a different date tabl...
Need Help
Show and Tell
NickolajJessen's avatar
NickolajJessen
Icon for Solution Sage rankSolution Sage
4 years ago

I'm not quite able to grasp what you are looking for in your expected output

SG2015's avatar
SG2015
Frequent Visitor
4 years ago

Hi NikolajJessen

 

Thanks for asking.

I want to create a YTD measure for price without using a second visual-date-filter on D_DATE_SALES, but instead use the value from visual-date-filter from D_DATE_EOM.

 

If I had two visual-date-filters in my report, I easily could create the Price YTD measure like

Price YTD = TOTALYTD(F_SALES[Price],D_DATE_SALES[Date]).

 

 

But if I don't want to have the second Date-Filter in my Report, is it possible to somehow reference the value from first filter to calculate Price YTD? I don't know whether this is possible at all - just asking. 

I hope it is clearer now.

 

Thanks for any hint.

Sinan