I have a data blending implemented to restrict the date filter.
I have a date filter along with 2 measures. When I choose a month then Measure 1 should be for selected month and Measure 2 should be for previous month. The formula looks like below
Division=(Measure 1 for Current Month)/(Measure 2 for previous month).
The calculation of Division should be:
LOOKUP([Measure 1_Calc],1)/LOOKUP([Measure 2_Calc],0)
Hope it helps.
Become a Viz Whiz on the Forums!
Support the Community and master Tableau.
Retrieving data ...