Forum Discussion

Petanek333's avatar
Petanek333
Icon for Helper III rankHelper III
4 years ago

Calculate changes between dates for various data categories

Hi,  I have a table like this. and a date slicer 'Calendar'[Dates]    There is data about stock movement in the table StockTable. Column "Type" is for distinguishing between increase...
Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi Petanek333 - I would like to suggest simplifying the DAX by changing the way you import the data.  This would involve removing the "Type" (increase / decrease) and changing the Quantity to +/-.  Now the DAX would simply add the quantity movements between the required dates.

  • Petanek333's avatar
    Petanek333
    Icon for Helper III rankHelper III
    4 years ago

    Hi Anonymous  and thank you for your suggestion. I will do it. Will be still struggling with the DAX though 🙂