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

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
NavaneethArra
Regular Visitor

how to get max of particular category based on category not by value

 

Runtype
BOP
Assumption 1
Assumption 2
Assumption 3
Roll forward EOP
Population update EOP

 

output to be as below based on dynamic selection

Runtype
BOP
Assumption 3
Roll forward EOP
Population update EOP

 

 

I have 4 Quarters slicers selection, based on the slicer selection the assumptions gets added or removed ... i wanted to show the latest assimption along with the remaining BOP,roll forward EOP and Population 

 

2 REPLIES 2
NavaneethArra
Regular Visitor

Hi 

Basically we get the quarterly data for these Run types , however all the Runtypes would be same but the assumptions gets added ,,,, and we need to show the latest assumption everytime whenever we select the slicer based on quarter 

For ex : 

We have Q3 2023 

where in we have 

BOP 
Assumption 1
Assumption 2
Population EOP 
Roll forward EOP

In this case i when i select Q3 2023 i should show the MAX of assumption which is Assumption 2 along with 
remaning run typres 

Like 

BOP
Assumptions2
Roll forward EOP 
Population update EOP

 

Runtype
BOP
Assumption 1
Assumption 2
Assumption 3
Roll forward EOP
Population update EOP
lbendlin
Super User
Super User

Please provide a more detailed explanation of what you are aiming to achieve. What have you tried and where are you stuck?

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

Check out the February 2024 Power BI update to learn about new features.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.