Skip to main content
cancel
Showing results for
Search instead for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Helper 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 minimum price for the article.

Input tableMatrix

1 ACCEPTED SOLUTION
Super User

I believe that you want something like my Multi-Column Aggregations (MC Aggregations) Quick Measure:

https://community.powerbi.com/t5/Quick-Measures-Gallery/Multi-Column-Aggregations-MC-Aggregations/m-...

@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...
5 REPLIES 5
Regular Visitor

Hi,

I'm not sure if I can revisit this topic.

Model proposed works fine, now I need a table showing the stores and the total quantity of articles that have the minimum price. The idea would be every article is assigned to the store with min and getting a report about what articles are assigned to each store.

Could you help me please?

Super User

See if my multi-column aggregations will work (MC Aggregations): https://community.powerbi.com/t5/Quick-Measures-Gallery/Multi-Column-Aggregations-MC-Aggregations/m-...

Not sure I fully understand what you are going for. Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...
Helper 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

Helper 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

Super User

I believe that you want something like my Multi-Column Aggregations (MC Aggregations) Quick Measure:

https://community.powerbi.com/t5/Quick-Measures-Gallery/Multi-Column-Aggregations-MC-Aggregations/m-...

@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...

## Helpful resources

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

#### Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

#### Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

#### New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

Top Solution Authors
Top Kudoed Authors