cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
SL_1983 Helper I
Helper I

Re: Retrieve the lowest price of each Producttype with the same Product_ID

I've tried it using a calculated table.

I would however prefer to use a calculated measure.
How should I do that?
Super User IV
Super User IV

Re: Retrieve the lowest price of each Producttype with the same Product_ID

What is a calculated measure? There is no such object in the Power BI parlance.

Do you mean a measure or a calculated column?

Best
D
SL_1983 Helper I
Helper I

Re: Retrieve the lowest price of each Producttype with the same Product_ID

Yes, sorry, i mean a measure
Highlighted
SL_1983 Helper I
Helper I

Re: Retrieve the lowest price of each Producttype with the same Product_ID

My excelsheet looks as follows (only a few items are listed as an example):

Recipe_ID

Recipe_Description

Recipe_Pers

RecipeProduct_ID

Product_ID

Product_Description

Recipe_Qty

Brand_ID

Package_ID

Package_Description

Package_Qty

Package_Measure

Price

Measure

1

Spaghetti Bolognese

4

9001

626

Champignons Parijs

0,25

241

954

Everyday Champignons Middelgroot

0,5

Kg

2,98

Kg

1

Spaghetti Bolognese

4

9001

626

Champignons Parijs

0,25

91

955

Boni Selection Champignons Extra Fijn

0,5

Kg

4,18

Kg

1

Spaghetti Bolognese

4

9001

626

Champignons Parijs

0,25

241

956

Everyday Champignons Fijn

0,25

Kg

4,2

Kg

1

Spaghetti Bolognese

4

9001

626

Champignons Parijs

0,25

91

957

Boni Selection Champignons Gesneden

0,3

Kg

5,3

Kg

1

Spaghetti Bolognese

4

9001

626

Champignons Parijs

0,25

91

958

Boni Selection Champignons Heel

0,195

Kg

4,87

Kg

1

Spaghetti Bolognese

4

9001

626

Champignons Parijs

0,25

91

959

Boni Selection Champignons Mini

0,39

Kg

5

Kg

1

Spaghetti Bolognese

4

9004

1284

Gehakt Kalf Varken

1

NULL

1993

Gehakt Kalfs- En Varkensvlees

0,5

Kg

8,45

Kg

1

Spaghetti Bolognese

4

9004

1284

Gehakt Kalf Varken

1

241

1994

Everyday Gehakt Varken-Kalf

0,5

Kg

7,28

Kg

 

For Recipe ID = 1 (Spaghetti) I want to calculate the total cost of the recipe using the Product_ID's with the lowest Price.

I've created two calculated colums:

- Lowest Price

- Lowest Price per Package

 

I've tried to write a measure using calculate, but that didn't work.

Can you help me on this?

 

Thank you.

 

Kind regards,

Sarah

 

Super User IV
Super User IV

Re: Retrieve the lowest price of each Producttype with the same Product_ID

Please find a file attached with a solution that uses a star schema and does not calculate the minimum price as a calculated column.

 

Best

D

View solution in original post

SL_1983 Helper I
Helper I

Re: Retrieve the lowest price of each Producttype with the same Product_ID

Thenk you for all your help.

 

Helpful resources

Announcements
New Ranks Launched March 24th!

New Ranks Launched March 24th!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power BI Community!

‘Better Together’ Contest Finalists Announced!

‘Better Together’ Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

Arun 'Triple A' Event Video, Q&A, and Slides

Arun 'Triple A' Event Video, Q&A, and Slides

Missed the Arun 'Triple A' event or want to revisit it? We've got you covered! Check out the video, Q&A, and slides now.

Community Summit North America

Community Summit North America

Innovate, Collaborate, Grow. The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors
Top Kudoed Authors