Home Forums Power Pivot Cumulative toral till date

This topic contains 2 replies, has 1 voice, and was last updated by  Luca 4 months ago.

Viewing 3 posts - 1 through 3 (of 3 total)
  • Author
    Posts
  • #14395

    Luca
    Participant
    • Started: 5
    • Replies: 10
    • Total: 15

    HI,

    i am trying to solve this problem. I solved similar ones but i am not able to do the same this time.

    Revenues by Confirmation Date (CY)

    CALCULATE([Revenues (CY)];USERELATIONSHIP(SalesDatabase1[confirmation date];Calendar1[Calendar Day]);YEAR(SalesDatabase1[reservation date])=2019)

    Revenues by confirmation date Cumulative:

    CALCULATE([Revenues by Confirmation Date (CY)];FILTER(ALL(Calendar1[Calendar Day]);Calendar1[Calendar Day]<=MAX(Calendar1[Calendar Day])))

    It Works but it doesnt stop at “Max Date” of SalesTable.

    I tried to add to the previous

    && Calendar1[Calendar Day]<=[cut-off Date]  —- with [cut-off Date]=

    CALCULATE(LASTDATE(SalesDatabase1[Confirmation Date]);ALL(SalesDatabase1);SalesDatabase1[Value]>0)

    but it doesnt work

    Any suggestion?

    thanks

    Luca

     

     

    #14396

    Luca
    Participant
    • Started: 5
    • Replies: 10
    • Total: 15

    Solved

    sorry

    #14397

    Luca
    Participant
    • Started: 5
    • Replies: 10
    • Total: 15

    Nothing solved, i am retard

    Pls help

    thanks

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic.