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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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
July 2024 Power BI Update

Power BI Monthly Update - July 2024

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

July Newsletter

Fabric Community Update - July 2024

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

Top Solution Authors