Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Puja
Helper III
Helper III

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 6
Ajendra
Resolver I
Resolver I

Hello,

 

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

 

Thanks!

Ajendra Rawat

Hi ,

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

Puja_0-1683658281302.png

 

Thank you 

hi @Puja 

why 29%, not the others?

Hi @FreemanZ ,

This is my request

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

Thank you

Hi @Puja 

You have multiple lines show A23, rank2, previous year. Why line 5/28/2022 stand out?

Thts what user want to see. 

When the Catogery is selected , like A23, or B22 in slicer, it should pick Previous Year May Rank2 data only.

@Anonymous  could you please help. I tried the whole day yesterday, couldnt get it correctly.

Thanks much.

 

Thanks.

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.