DAX Approach to Inventory Problem?

• imani_technology

  SSCrazy Eights

  Points: 8200

  More actions

  September 30, 2020 at 12:42 am

  #3791783

  I have data in AAS (Tabular) that looks like the following table.  I need to create two calculated columns for the Date that the Inventory Changed and the Amount of the Inventory Change.  I think and IF function can take care of me for the date of the inventory changed.  However, I'm stumped regarding how to calculate the amount of the inventory change.

  What are some logical approaches to that?

  

• Martin Schoombee

  SSCoach

  Points: 19128

  More actions

  September 30, 2020 at 12:14 pm

  #3791901

  This article should point you in the right direction: https://www.sqlbi.com/articles/understanding-the-difference-between-lastdate-and-max-in-dax/