Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi guys, I am fairly new to power bi and am trying to learn. I have a case and want to see if power bi is able to do this. So the case goes like this,
I have multiple products, let's say A, B, C, D that can be sourced from multiple sources S1, S2, S3 and each source has its own cost for specific assets. Sample dataset would like below : -
| Asset | Source | Cost |
| A | S2 | 1000 |
| B | S3 | 2000 |
| C | S1 | 3000 |
| A | S3 | 500 |
| B | S1 | 4000 |
| A | S1 | 1500 |
| B | S2 | 2500 |
| C | S2 | 3000 |
Now would it be possible to create a measure that returns a value indicating where I should order asset A from - S1, S2, or S3 so I can get the same product from the cheapest source. Maybe it can be possible to select a number of sources and the measure will calculate based on the selected sources.
Any help will be very appreciated!
Thank you!
Solved! Go to Solution.
Hi,
You may download my PBI file from here.
Hope this helps.
Hi,
You may download my PBI file from here.
Hope this helps.
@asad98 , USe this for source and Min for cost
Min Source =
VAR __id = MAX ('Table'[Asset] )
VAR __Cost = CALCULATE ( MIN('Table'[Cost] ), ALLSELECTED ('Table' ), 'Table'[Asset] = __id )
RETURN CALCULATE ( MIN ('Table'[Source] ), VALUES ('Table'[Asset ),'Table'[Asset] = __id,'Table'[Cost] = __Cost )
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
98 | |
86 | |
70 | |
62 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |