Forum Discussion

LinkeLoutje's avatar
LinkeLoutje
Regular Visitor
8 years ago

Variable target weight

Hi, I'm looking at a logistics dashboard where targets need to be readjusted based on the current period and since I'm new to PowerBI I'm looking for the best method. 

 

 

The situation is as follows. 

We need to have the freight planned early. Therefore it is needed to look 13 weeks into the future to check whether contracts are sealed. For example: We expect to move 400 tonnes of freight. 13 weeks ahead we need to make sure 75% of our target is planned. 

Thus the target from the cube will correctly list 400 tonnes as a target, but 13 weeks ahead it should list 300 tonnes. However, while we move in time the weight of the target should go up until 100%, thus 400 tonnes, 4 weeks ahead. 

 

Where and how can I add the variability?

 

Thanks!

 

Need Help

3 Replies

  • Floriankx's avatar
    Floriankx
    Solution Sage
    8 years ago

    Hello you could try to use DATEDIFF

     

    13Weeks:=CALCULATE(SUM(Freigt[Weight]),DATESINPERIOD(TODAY(),13*7,days))

     

    %13Weeks:=Divide([13Weeks]/400

     

    With 4 weeks it is similar.

    • LinkeLoutje's avatar
      LinkeLoutje
      Regular Visitor
      8 years ago

      Thanks Florian,

       

      I did think about something like it, but the thing is that the weight is going down per week, from week 4 onwards, until being 0%. I believe the formula will become increasingly complicated?

       

      • Floriankx's avatar
        Floriankx
        Solution Sage
        8 years ago

        Hello, can you give some simplified sample data and your expected result?