Forum Discussion

MWitkin's avatar
MWitkin
Frequent Visitor
10 years ago
Solved

Cumulative Line Formula

Hello. I need to draw a cumulative line across this graph for both columns represented as bars in this graph visual: Both columns are date columns and are on the same table, and the bars r...
Need Help
Tutorial Requests
  • Twan's avatar
    Twan
    10 years ago

    You should be able to use the formula that Greg_Deckler provided and just change the SUM to a COUNT of [Planned] or [Actual].

     

     

    Cummulative Actual Line =
CALCULATE (
    COUNTA ( 'Table1'[Actual] ),
    FILTER (
        ALL ( 'Table1' ),
        'Table1'[StartofMonth] <= MAX ( 'Table1'[StartofMonth] )
    )
)

    Cummulative Planned Line =
    CALCULATE (
        COUNTA ( 'Table1'[Planned] ),
        FILTER (
            ALL ( 'Table1' ),
            'Table1'[StartofMonth] <= MAX ( 'Table1'[StartofMonth] )
        )
    )

     

    Here is what I generated with your example data set.

     

     

sandrasanchez's avatar
sandrasanchez
Advocate I
10 years ago

Hi!

I have this DAX formula and it doesn't works for me, what am I doing wrong?

Thanks so much!!

 

Importe Acumulado = CALCULATE (
    SUM ( 'InvoiceSet'[Amount PreTax] );
    FILTER (
        ALL ( InvoiceSet[Invoice Date] );
        InvoiceSet[Invoice Date] <= MAX ( InvoiceSet[Invoice Date] )
    )
)

  • Vvelarde's avatar
    Vvelarde
    Community Champion
    10 years ago

    EL filtro debe de ir la tabla

     

    FILTER (
            ALL ( InvoiceSet)