Forum Discussion

Cuscino's avatar
Cuscino
Frequent Visitor
8 years ago

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

Need Help
Tips and Tricks

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Hi Cuscino,

     

    For your requirement , you need to add a condition to check total level, then write a formula to calculate with your logic to replace original calculate result.

     

    Please provide some sample data and measure formula to help us clarify your table structure and coding formula.

     

    Regards,

    Xiaoxin Sheng