Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Join us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.

Reply
Puja
Helper III
Helper III

Help please.

‎05-09-2023 10:45 AM

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

Message 1 of 7
607 Views
0
6 REPLIES 6
Ajendra
Resolver I
Resolver I

‎05-09-2023 11:21 AM

Hello,

 

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

 

Thanks!

Ajendra Rawat

Message 2 of 7
574 Views
0
Puja
Helper III
Helper III
In response to Ajendra

‎05-09-2023 11:40 AM

Hi ,

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

Puja_0-1683658281302.png

 

Thank you 

Message 3 of 7
569 Views
0
FreemanZ
Super User
Super User
In response to Puja

‎05-09-2023 03:40 PM

hi @Puja 

why 29%, not the others?

Message 4 of 7
546 Views
0
Puja
Helper III
Helper III
In response to FreemanZ

‎05-09-2023 04:15 PM

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

Message 5 of 7
538 Views
0
FreemanZ
Super User
Super User
In response to Puja

‎05-09-2023 07:11 PM

Hi @Puja 

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

Message 6 of 7
518 Views
0
Puja
Helper III
Helper III
In response to FreemanZ

‎05-10-2023 04:09 AM

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.

Message 7 of 7
510 Views
0

Helpful resources

Announcements
July PBI25 Carousel

Power BI Monthly Update - July 2025

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

Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 community update carousel

Fabric Community Update - June 2025

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

View All