Dynamics F/SCM Customer Experience (CRM) Dynamics GP Dynamics Business Central (NAV) Dynamics SL Power Platform Fabric Copilot

[Jerome Charbonnier]

Hello,

I’m trying to manipulate some forecast.

 

The forecast (Somme Qty Prev) is inputted each month, with different labels (“06+06”, “07+05”)

You can see the “Realised” and the “Forecast (Qty Prev)” in the blue columns.

To be able to select and disaplay on old Forecast, I need to deselect the “Gray Line” that did not exist at this period.

Each forecast, inputted with a dedicated label has a Ref forecast date “01/07/2017” in the case of “06+06”. The “Realised” Data has a unique date fixed to “02/01/2017”.

There is a slicer to select the “Realised” value and the forecast to display.

I tried several mesures (BFD = Beguin forecast Date)

BFD1:=CALCULATE(MAX(Prestations[ref forecast date]);ALLSELECTED(Prestations[Ref forecast date]))

BFD2:=CALCULATE(MAX(Prestations[ref forecast date]);ALLEXCEPT(prestations;Prestations[Ref forecast date]))

BFD3:=CALCULATE(MAX(Prestations[Ref forecast date]);ALL(Prestations[Ref forecast date]))

 

Qty measures should settled the right quantity depeding on the forecast selected date.

QtyPrev2:=CALCULATE(SUM([Qty]);Prestations[BudgetRéalisé]=“Prev”;filter(Prestations;[BDF1]<=Prestations[Date]))

QtyPrev3:=CALCULATE(SUM([Qty]);filter(prestations;Prestations[Date]<[BDF1]))

 

As you an see, none of them is working, because at the “Realised” level, despite the beguining forecast displayed column, the real BDF1 used value is “02/01/2017”, the one of “Realized”.

 

I am getting completely stuck.

 

Any Idea?

Thanks in advance

 

——————————
Jerome Charbonnier
Senior Manager
Primis
Neuilly sur seine
0778473041
——————————