cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
bhawna_aashri
Frequent Visitor

Finding MAX/MIN value at sub category level ( sub category is being fetched from another table.)

HEY all,
I am fetching data at multiple row level and from diffrent tables (3 to be precise) i need to fetch the max and min at the first column level. Please help me in creating  both column and measures.

 

bhawna_aashri_0-1605719544270.pngbhawna_aashri_1-1605719572103.png

the output visual should be like below :

bhawna_aashri_2-1605719676801.png

Help is appreciated 🙂 

 

 

4 REPLIES 4
amitchandak
Super User IV
Super User IV

@bhawna_aashri ,The information you have provided is not making the problem clear to me. Can you please explain with an example.
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
Appreciate your Kudos.



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

hey Amit @amitchandak  , let me re phrase my issue .
1. we are fetching the data from 3 tables to be pricise . After inputting the data and perfoming data moddeling . the input report is PFB .

 

the aim is to group the data by first column name and find the min and max volume per each category name in column one (such as KIbali ,Jabal Sayeed etc .)

the output should be PFB.

MineGold COG (gm/t)
MinMax
Bulyanhulu0.340.41
Buzwagi0.440.44
Jabal Sayid0.480.51
Kibali0.550.65
Loulo Gounkoto0.690.83


Please note the first column is being fetched by table 1 lets say mine and second column by table name lets say site and table 3 had the numeric data (cutoff colun and recovery column )

daxer-almighty
Solution Sage
Solution Sage

You have not received any reply within 5 hours... That means nobody understands what you're asking about. Please refer to this article to know how to get your question answered. Thanks.

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

secondImage

Are You Ready?

Test your skills now with the Cloud Skills Challenge.

Top Solution Authors