Forum Discussion

setis's avatar
setis
Post Partisan
5 years ago
Solved

Cumulative amount until EOM

Dear experts,    I have a measure that calculates the overdue amount of all cases with a "Due date" on the selected month.    It looks like this:     Overduev2.1 = CALCULATE( SUMX( FILTE...
Need Help
  • amitchandak's avatar
    amitchandak
    5 years ago

    setis , Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

     

    Date table should be joined with Due date and try like

     

    Overduev2.2 =
    CALCULATE(
    SUMX(
    FILTER('ALL$Cust_ Ledger Entry', (ISBLANK('ALL$Cust_ Ledger Entry'[Posting date DCLE])||
    'ALL$Cust_ Ledger Entry'[Posting date DCLE] > 'ALL$Cust_ Ledger Entry'[Due Date])), [OpenSales]),
    FILTER(ALLSELECTED('Date'),
    'Date'[Date] <= max('Date'[Date]) && 'Date'[Date] <=today())

     

     

    if there is due and it need to be carried fwd this should work

Greg_Deckler's avatar
Greg_Deckler
Community Champion
5 years ago

setis Can you post sample data as text and expected output? Much easier to mock up a solution that way.