Forum Discussion

BLM's avatar
BLM
Icon for Helper I rankHelper I
8 years ago
Solved

Cumulative Totals

hello guys!! I need an aummulative summ by date (only selected in slicer) and by another field (stock OPs). I attached a image for  show that I need. Thank you (sorry for my english)
  • v-jiascu-msft's avatar
    v-jiascu-msft
    8 years ago

    Hi BLM,

     

    You need a measure like this:

    Measure =
CALCULATE (
    SUM ( movimientos[Cantidad] ),
    FILTER (
        ALLSELECTED ( 'calendar' ),
        'calendar'[fecha] <= MAX ( 'calendar'[fecha] )
    )
)

    Cumulative_Totals

     

    Best Regards,

    Dale

BLM's avatar
BLM
Icon for Helper I rankHelper I
8 years ago

help me please...:smileyfrustrated:

v-jiascu-msft's avatar
v-jiascu-msft
Icon for Microsoft Employee rankMicrosoft Employee
8 years ago

Hi BLM,

 

Can you share a dummy sample? It's hard to write a DAX formula without the data model.

 

Best Regards,

Dale

    • v-jiascu-msft's avatar
      v-jiascu-msft
      Icon for Microsoft Employee rankMicrosoft Employee
      8 years ago

      Hi BLM,

       

      You need a measure like this:

      Measure =
CALCULATE (
    SUM ( movimientos[Cantidad] ),
    FILTER (
        ALLSELECTED ( 'calendar' ),
        'calendar'[fecha] <= MAX ( 'calendar'[fecha] )
    )
)

      Cumulative_Totals

       

      Best Regards,

      Dale