To get cumulative only at one field RRS feed

  • Question

  • Hi,

    I have prepared a report.I need to get the cumulative value using DAX only at the point where quantity exists

    As an example,for the date 12/29/2017 there is a quantity -2 in Planned Order Demand.

    I would like to have a field Cummulative as that it should show up the value only at the date where quantity exists(it is not equal to zero) (on 12/29/2017 in our case).

    Presently it is representing the value -2 across all the dates.So can you suggest a way of achieving it in DAX?

    Wednesday, January 3, 2018 3:04 PM


All replies