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

Reply
Fraistan
Helper I
Helper I

Change supplier after a breakpoint, keep the historic data but change new data

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 NamePart NumberPrice Per UnitBreakpoint
Supplier A6503041000340000
Supplier B650304950 



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?

0 REPLIES 0

Helpful resources

Announcements
Europe Fabric Conference

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.

AugPowerBI_Carousel

Power BI Monthly Update - August 2024

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

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

Sept NL Carousel

Fabric Community Update - September 2024

Find out what's new and trending in the Fabric Community.