Results 1 to 2 of 2

Thread: Sleeper: DAX Formula sum previous period

  1. #1
    VBAX Newbie
    Joined
    Mar 2018
    Posts
    3
    Location

    Sleeper: DAX Formula sum previous period

    Hi Everyone

    I m lookng for a DAX Formula (Measure):

    2018w1 2018w2
    Demand 1 0
    Stock 6 2
    PO 3 1

    Total 4 5

    Total= Stock - Demand - PO
    Basically the first period is normal, but those onwards should sum up also the previous Total

    Demand, stock and PO are in the same table, Period in another one
    I have a slicer with all the Components , and the first Period (in the example above) is always changing (the first one in the source table is 2015w1)

    Thanks

  2. #2
    Distinguished Lord of VBAX VBAX Grand Master Bob Phillips's Avatar
    Joined
    Apr 2005
    Posts
    25,446
    Location
    Not sure I understand the data, can you post a sample workbook and tell us expected results?
    ____________________________________________
    Nihil simul inventum est et perfectum

    Abusus non tollit usum

    Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
    James Thurber

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •