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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

Circular dependency issue impossible to resolve ?

HI guys,

 

I think i need your help on a new developpment I try to do on my datas.

 

I have two tables with data related to my business :

 

The Program table is what I have sold to my client. He has reserved some slots on my production calendar for a precise date, operation and vehicle type.

 

The Program table looks like this :

 

Vehicle typeOperationSiteDate
E71ATPMCB.F.C.17/01/2018
E71ATPMCB.F.C.22/01/2018
E71ATPMCB.F.C.08/02/2018
E71ATPMCB.F.C.19/03/2018
E71ATPMCB.F.C.19/04/2018
E71ATPMCB.F.C.11/06/2018

 

The Realization table is what the client has delivered to us. In this second table there is the vehicle number and its type, operation, site and date of delivery.

 

In my contract the slot is reserved for 30 days, so the client can deliver its vehicle in a -15 / +15 shift. What i'm trying to do is to add a column in the Program table who will show what vehicle number takes the slot, and one in the Realization table which will show the date of the slot taken. (Empty if no slot taken)

 

The realization table looks like this :

 

ImmatriculationVehicle typeOperationSiteDate
118739017051R80ATPMCN.P.D.C.08/01/2018
118739024560R80ATPMCN.P.D.C.09/01/2018
118739026144R80ATPMCLorraine10/01/2018
118739026227R80ATPMCAlsace05/01/2018
118739026482R80ATPMCLorraine10/01/2018

 

A few rules : the first vehicle to enter the -15 / +15 shift on a slot is taken the slot. Of course only one vehicle can enter a slot.

 

I've tried to do this but i always finish on a circular depedency... Someone could help ?

4 REPLIES 4
v-chuncz-msft
Community Support
Community Support

@Anonymous,

 

Here is an example for your reference.

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Anonymous
Not applicable

Thanks but I dont understand how to use the MAXX function to solve my problem.

 

Only one vehicle can occupy one slot, and I can't figure how to achieve this...

Anonymous
Not applicable

Capture.JPG

 

Here is an example to make it clear, i made a crossjoin between my slot table and entry table.

 

The slot 42 is reserved on the NPDC site, for an ATPSUR operation on a S58 type the 06/01/2018. So it can be taken by a vehicle entered between 22/12/2017 and 21/01/2018. I have 11 vehicles that have entered my site between these two dates, so the first one will take the slot, the immatriculation 318747721013.

 

It's easy because its the first slot for this site, operation and vehicle type. But for the second one, the slot number 50, i would like to find a way to exclude the 318747721013 vehichle because it took the first slot, and say that this slot is taken by the vehicle 318747710172.

 

So for each slot the result depends of the results of the past slots, it's looks like a loop and i dont know how to code this. Anyone on this ?

 

I'm lost and it's a very important feature for me 🙂

 

Anonymous
Not applicable

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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