Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
Solved! Go to 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
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.
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.
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
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |