Forum Discussion
RonLieuw
8 years agoHelper I
Calculating minimum value in a row with several columns
HI there, I am trying to calcuate the min/max price of articles sold by stores. The first picture shows my (pivoted) input table The second picture the matrix, here I want to add a column with the...
- 8 years ago
I believe that you want something like my Multi-Column Aggregations (MC Aggregations) Quick Measure:
RonLieuw
8 years agoHelper I
Hi Greg, I down loaded your pbix file and loved it how you added all the aggregations.
But my source is different, Sample pbix file, I don't have the value1 ... value4 as columns is my input data.
Can you me help with my setup?
RonaldL
RonLieuw
8 years agoHelper I
Hi, is it at all possible to aggregate data (e.g minimum, maximum) in a source as shown in the url.
https://www.dropbox.com/s/9hejfcpvnn24xb7/FPK-Back-2-School-2017-final.pbix?dl=0
Thanks
RonaldL
- Greg_Deckler8 years agoCommunity Champion
I believe that you want something like my Multi-Column Aggregations (MC Aggregations) Quick Measure: