The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event: Join us in Stockholm, September 24-27, 2024.
Save €200 with code MSCUST on top of early bird pricing!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
Hi,
I have a spend dashboard that are being shown to the business
We are manufacturing products, therefor we have suppliers of different components (part number/SKU).
When we change suppliers, the change is decided by a breakpoint in Serial Number.
Component: 650304
Supplier A before serial number: 340000
Supplier B after serial number: 340000
Of course there is also a change in price when we change supplier.
The raw data we can manipulate, these changes doesn't occur that often.
I have 4 columns
Supplier name
Part number
Price per Unit
Breakpoint (in serial number).
Supplier Name | Part Number | Price Per Unit | Breakpoint |
Supplier A | 650304 | 1000 | 340000 |
Supplier B | 650304 | 950 |
How should I do with the raw data and what formula could i use to save the historical data but change the supplier after a certain breakpoint?
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the August 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
21 | |
18 | |
16 | |
15 | |
14 |
User | Count |
---|---|
39 | |
32 | |
22 | |
19 | |
18 |