cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Ratax Regular Visitor
Regular Visitor

utilizing relationship to calculate min and max

Hello Smiley Happy

I have a problem i need help with.

 

I have alot of measurements mashed up in a data table, i wanna calculate the min and max for the ratio column for each different group in the number column.

Sitdownson.png

 

I want these min and max values displayed in the overview table of all the different nr (the Max column is missing)

 

Sitdownson2.png

Hope someone can help

 

Regards Ratax

 

2 ACCEPTED SOLUTIONS

Accepted Solutions
Community Support Team
Community Support Team

Re: utilizing relationship to calculate min and max

Hi @Ratax,

 

I made one sample for your reference.

 

Create two calculated columns in the target table.

 

MAX = CALCULATE(MAX(Table1[Ratio]),ALLEXCEPT(Table2,Table2[Anti]))
Min = CALCULATE(MIN(Table1[Ratio]),ALLEXCEPT(Table2,Table2[Anti]))

Capture.PNG

 

For more details, please check the pbix as attached.

 

Regards,

Frank

Community Support Team _ Frank
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Super User
Super User

Re: utilizing relationship to calculate min and max

Hi,

 

Try these calculated column formulas

 

Max=CALCULATE(MAX(Data[Ratio]),FILTER(Data,Data[Nr]=EARLIER(Data[Nr])))

Min=CALCULATE(MIN(Data[Ratio]),FILTER(Data,Data[Nr]=EARLIER(Data[Nr])))

 

Hope this helps.

2 REPLIES 2
Community Support Team
Community Support Team

Re: utilizing relationship to calculate min and max

Hi @Ratax,

 

I made one sample for your reference.

 

Create two calculated columns in the target table.

 

MAX = CALCULATE(MAX(Table1[Ratio]),ALLEXCEPT(Table2,Table2[Anti]))
Min = CALCULATE(MIN(Table1[Ratio]),ALLEXCEPT(Table2,Table2[Anti]))

Capture.PNG

 

For more details, please check the pbix as attached.

 

Regards,

Frank

Community Support Team _ Frank
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Super User
Super User

Re: utilizing relationship to calculate min and max

Hi,

 

Try these calculated column formulas

 

Max=CALCULATE(MAX(Data[Ratio]),FILTER(Data,Data[Nr]=EARLIER(Data[Nr])))

Min=CALCULATE(MIN(Data[Ratio]),FILTER(Data,Data[Nr]=EARLIER(Data[Nr])))

 

Hope this helps.