Evaluate the Quarter and then assign a value

[Diptarup]

Hi All,

I have two tables one is a date table and another table with the value. I am using a date in slicer from table 1. My requirenment is that - if I select any Quarter from QuarterIn Calendar from the Date table, it should first compare with the dates in my second table and if the Quarter and Year in the second table is less than the dates table then the value would be "NV" corresponding to product or "ES" if its greater than the Quarter and Year in the second table.

Date Table

Date	QuarterInCalendar
Friday, April 16, 2027	Q2 2027
Friday, April 2, 2027	Q2 2027
Friday, April 23, 2027	Q2 2027
Friday, June 4, 2027	Q2 2027
Friday, March 12, 2027	Q1 2027
Friday, March 19, 2027	Q1 2027
Friday, March 26, 2027	Q1 2027
Friday, March 5, 2027	Q1 2027
Friday, May 14, 2027	Q2 2027
Friday, May 21, 2027	Q2 2027
Friday, May 28, 2027	Q2 2027
Friday, May 7, 2027	Q2 2027
Friday, November 12, 2027	Q4 2027
Friday, November 19, 2027	Q4 2027
Friday, November 26, 2027	Q4 2027
Friday, November 5, 2027	Q4 2027
Friday, October 1, 2027	Q4 2027
Friday, October 15, 2027	Q4 2027
Friday, October 22, 2027	Q4 2027
Friday, October 29, 2027	Q4 2027
Friday, October 8, 2027	Q4 2027
Friday, September 10, 2027	Q3 2027
Friday, September 17, 2027	Q3 2027
Friday, September 24, 2027	Q3 2027
Friday, September 3, 2027	Q3 2027
Monday, April 12, 2027	Q2 2027
Monday, April 19, 2027	Q2 2027
Monday, April 26, 2027	Q2 2027
Monday, April 5, 2027	Q2 2027
Monday, August 16, 2027	Q3 2027
Monday, August 2, 2027	Q3 2027
Monday, August 23, 2027	Q3 2027
Monday, August 30, 2027	Q3 2027
Monday, August 9, 2027	Q3 2027
Monday, December 13, 2027	Q4 2027
Monday, December 20, 2027	Q4 2027
Monday, December 27, 2027	Q4 2027
Monday, December 6, 2027	Q4 2027
Monday, February 1, 2027	Q1 2027
Monday, February 15, 2027	Q1 2027
Monday, February 22, 2027	Q1 2027
Monday, February 8, 2027	Q1 2027
Monday, January 11, 2027	Q1 2027
Monday, January 18, 2027	Q1 2027
Monday, January 25, 2027	Q1 2027
Monday, January 4, 2027	Q1 2027
Monday, July 12, 2027	Q3 2027
Monday, July 19, 2027	Q3 2027
Monday, July 26, 2027	Q3 2027
Monday, July 5, 2027	Q3 2027
Monday, September 6, 2027	Q3 2027
Saturday, April 10, 2027	Q2 2027
Saturday, April 17, 2027	Q2 2027
Saturday, April 24, 2027	Q2 2027
Saturday, April 3, 2027	Q2 2027
Saturday, August 14, 2027	Q3 2027
Saturday, August 21, 2027	Q3 2027
Saturday, August 28, 2027	Q3 2027
Saturday, August 7, 2027	Q3 2027
Saturday, December 11, 2027	Q4 2027
Saturday, December 18, 2027	Q4 2027
Saturday, December 25, 2027	Q4 2027
Saturday, December 4, 2027	Q4 2027
Saturday, February 13, 2027	Q1 2027
Saturday, February 20, 2027	Q1 2027
Saturday, February 27, 2027	Q1 2027
Saturday, February 6, 2027	Q1 2027
Saturday, January 16, 2027	Q1 2027
Saturday, January 2, 2027	Q1 2027
Saturday, January 23, 2027	Q1 2027
Saturday, January 30, 2027	Q1 2027
Saturday, November 27, 2027	Q4 2027
Saturday, November 6, 2027	Q4 2027
Saturday, October 16, 2027	Q4 2027
Saturday, October 2, 2027	Q4 2027
Saturday, October 23, 2027	Q4 2027
Saturday, October 30, 2027	Q4 2027
Saturday, October 9, 2027	Q4 2027
Saturday, September 11, 2027	Q3 2027
Saturday, September 18, 2027	Q3 2027
Saturday, September 25, 2027	Q3 2027
Saturday, September 4, 2027	Q3 2027
Sunday, April 11, 2027	Q2 2027
Sunday, April 18, 2027	Q2 2027
Sunday, April 25, 2027	Q2 2027
Sunday, April 4, 2027	Q2 2027
Sunday, August 1, 2027	Q3 2027
Sunday, August 15, 2027	Q3 2027
Sunday, August 22, 2027	Q3 2027
Sunday, August 29, 2027	Q3 2027
Sunday, August 8, 2027	Q3 2027
Sunday, December 12, 2027	Q4 2027
Sunday, December 19, 2027	Q4 2027
Sunday, March 7, 2027	Q1 2027
Sunday, May 16, 2027	Q2 2027
Sunday, May 2, 2027	Q2 2027
Sunday, May 23, 2027	Q2 2027
Sunday, May 30, 2027	Q2 2027
Sunday, May 9, 2027	Q2 2027
Thursday, December 16, 2027	Q4 2027
Thursday, December 2, 2027	Q4 2027
Thursday, December 23, 2027	Q4 2027
Thursday, December 30, 2027	Q4 2027
Thursday, December 9, 2027	Q4 2027
Thursday, February 11, 2027	Q1 2027
Thursday, February 18, 2027	Q1 2027
Thursday, February 25, 2027	Q1 2027
Thursday, February 4, 2027	Q1 2027
Thursday, January 14, 2027	Q1 2027
Thursday, January 21, 2027	Q1 2027
Thursday, January 28, 2027	Q1 2027
Thursday, June 3, 2027	Q2 2027
Thursday, March 11, 2027	Q1 2027
Thursday, March 18, 2027	Q1 2027
Thursday, March 25, 2027	Q1 2027
Thursday, March 4, 2027	Q1 2027
Thursday, May 13, 2027	Q2 2027
Thursday, May 20, 2027	Q2 2027
Thursday, May 27, 2027	Q2 2027
Thursday, May 6, 2027	Q2 2027
Tuesday, April 6, 2027	Q2 2027
Tuesday, August 10, 2027	Q3 2027
Tuesday, August 17, 2027	Q3 2027
Tuesday, December 7, 2027	Q4 2027
Tuesday, February 16, 2027	Q1 2027
Tuesday, February 2, 2027	Q1 2027
Tuesday, February 23, 2027	Q1 2027
Tuesday, February 9, 2027	Q1 2027
Tuesday, January 12, 2027	Q1 2027
Tuesday, January 19, 2027	Q1 2027
Tuesday, January 26, 2027	Q1 2027
Tuesday, June 8, 2027	Q2 2027
Tuesday, March 16, 2027	Q1 2027
Tuesday, March 2, 2027	Q1 2027
Tuesday, March 23, 2027	Q1 2027
Tuesday, March 30, 2027	Q1 2027
Tuesday, March 9, 2027	Q1 2027
Tuesday, October 19, 2027	Q4 2027
Tuesday, October 26, 2027	Q4 2027
Tuesday, October 5, 2027	Q4 2027
Tuesday, September 14, 2027	Q3 2027
Tuesday, September 21, 2027	Q3 2027
Tuesday, September 28, 2027	Q3 2027
Tuesday, September 7, 2027	Q3 2027
Wednesday, August 4, 2027	Q3 2027
Wednesday, December 1, 2027	Q4 2027
Wednesday, December 15, 2027	Q4 2027
Wednesday, December 22, 2027	Q4 2027
Wednesday, December 29, 2027	Q4 2027
Wednesday, January 27, 2027	Q1 2027
Wednesday, January 6, 2027	Q1 2027
Wednesday, July 14, 2027	Q3 2027
Wednesday, July 7, 2027	Q3 2027

Second table

Product	Date
A	January 11, 2027
A	March 11, 2026
B	March 11, 2026
B	Feb 11, 2028
B	April 28, 2027
B	January 11, 2027
C	January 11, 2027
E	January 11, 2027
F	January 11, 2027
F	Saturday, October 30, 2027

[Diptarup]

Say I select Q2 2026 in Slicer, then my Product A should show 

NV for Product A whose date is January 11, 2027, as selected slicer date is after than the given date

ES for Product A whose date is March 11, 2026, as selected Slicer date is earlier than the given date

hope this is clear 

[lbendlin]

Please show the expected outcome based on the sample data you provided.