utilizing relationship to calculate min and max

[Ratax]

Hello 🙂

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.

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

Hope someone can help

Regards Ratax

[v-frfei-msft · Accepted solution]

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]))

For more details, please check the pbix as attached.

Regards,

Frank

[Ashish_Mathur · Accepted solution]

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.

[v-frfei-msft · Accepted solution]

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]))

For more details, please check the pbix as attached.

Regards,

Frank