Forum Discussion

ConfusedAnalyst's avatar
ConfusedAnalyst
Frequent Visitor
3 years ago
Solved

Adjusting the Starting Column for a Calculation based on the Latest Date for the specific Row

I'm creating a running inventory tracker for our company and I need the calculation to start only on the date that the inventory was updated for the material in question.  As you can see in ...
Need Help
  • ConfusedAnalyst's avatar
    ConfusedAnalyst
    3 years ago

    Unfortunately this issue was fixed by forcing a static starting date. It was very hard to trick powerBI into starting with blank data if data exists. It would have had to have been hardcoded per material which is not possible imo. I appreciate you trying to help Felix. 

MFelix's avatar
MFelix
Icon for Super User rankSuper User
3 years ago

Hi ConfusedAnalyst ,

 

Your issue is related with the calendar table, since you are forcing the beginning date to be for the Maximum value for a specific product you will get only the data after the start o f the calendar:

Since your calendar does not have dates before this you will not get expected result try this instead:

 

 

Concerning the onhand if you want this value to be updated with the last one create the following column on the HQMT table:

ONHAND TOTAL = 
MAXX(TOPN(1,FILTER(ALL(INMT), INMT[Material] = HQMT[Material]), INMT[LastCntDate], DESC), INMT[OnHand])

 

Now you can use has a separete column

 

If this does not suit your needs can you please share a little bit more insight on the calculations you need.