Forum Discussion

Puja's avatar
Puja
Helper III
3 years ago

Help please.

I have a  Date table with Date, Year and Rank  and Catogery table with season_catogery and season _Year.

My request is , when user select Season_Catogery A23, then the result should show (Previos year) 5/28/2022 (Rank 2 )measure output.

EX: According to below test data I need to see 29%  as a result. 

5/28/202220222A202329.00%

Here is the test data.

DateYearRankSeason_CategorySeason_YearMEASURE
   B2220230.00%
10/3/202020201B2220230.00%
10/17/202020202B2220230.00%
10/31/202020203B2220230.00%
11/3/202020201B2220230.00%
11/14/202020202B2220230.00%
12/5/202020201B2220230.00%
1/2/202120211B2220230.00%
1/16/202120212B2220230.00%
1/30/202120213A2320230.00%
2/13/202120211A2320230.00%
2/27/202120212A2320230.00%
3/20/202120211A2320230.00%
4/3/202120211A2320230.00%
4/17/202120212A2320230.00%
5/1/202120211A2320230.00%
5/15/202120212A2320230.00%
5/29/202120213A2320230.00%
6/19/202120211A2320230.00%
7/3/202120211A2320230.00%
7/17/202120212A2320230.00%
7/31/202120213A2320230.00%
8/14/202120211A2320230.00%
8/28/202120212A2320230.00%
9/18/202120211A2320230.00%
10/2/202120211A2320230.00%
10/19/202120212A2320230.00%
10/30/202120213A2320230.00%
11/13/202120211A23202318.15%
12/4/202120211A2320230.00%
1/1/202220221A2320230.00%
1/15/202220222A2320230.00%
1/29/202220223A2320238.77%
2/12/202220221A23202322.15%
2/26/202220222A23202322.77%
3/19/202220221A23202326.54%
4/2/202220221A23202328.55%
4/16/202220222A23202341.78%
4/30/202220223A23202342.55%
5/14/202220221A23202353.70%
5/28/202220222A23202329.00%
6/18/202220221A23202372.79%
7/2/202220221A23202380.24%
7/16/202220222A23202386.35%
7/30/202220223A23202390.52%
8/20/202220221A23202392.19%
9/3/202220221A23202394.04%
9/17/202220222A23202394.35%
10/1/202220221A23202394.34%

Thanks a lot

6 Replies

  • Ajendra's avatar
    Ajendra
    Resolver I
    3 years ago

    Hello,

     

    Desired output not clear to me can you please elaborate some more to it.

     

    Thanks!

    Ajendra Rawat

    • Puja's avatar
      Puja
      Helper III
      3 years ago

      Hi ,

      When user selects (in slicer)A23, the result should be 29% .

       

      Thank you