Forum Discussion

miracle2023's avatar
miracle2023
Icon for Helper I rankHelper I
3 years ago

Dynamic sum function to get assumed overdue cases in future

Hi,   I'm trying to build dax query which will calculate overdue cases for future. I have three measures and one calculated column for "Overdue": Measures: Current_due = CALCULATE(COUNTROWS(cust...
miracle2023's avatar
miracle2023
Icon for Helper I rankHelper I
3 years ago

Thank you for your reply. Here is the link :

Link 

some_bih's avatar
some_bih
Icon for Community Champion rankCommunity Champion
3 years ago

Hi miracle2023 

In your file there are 2 duplicates for Customer ID, this could affect reconciliation results.

Should we remove some rows, some leave? Which to remove?

 

In pbi there is no "Excel" terms as shown below:

Delivery will be some fix amount?

What about Falling due? It should be what?

On picture okt 2023 amount is negative - this is pure example? Calculation should include MIN (something..., 0), so 0 (zero) is minimum value or ...?

 

 

  • miracle2023's avatar
    miracle2023
    Icon for Helper I rankHelper I
    3 years ago

    Hi, 

    Thank you for your reply again.

    Yes delivery is static and will not be changed.

    Failing Due is Due based on deadline date. 

    I should've clarified that excel is basically my real data. I have 1225 overall cases for one team (all due + all overdues).

    Negative should stay the same - it means that resposnible team do very well and they have additional resources that can be re-allocated.

    • some_bih's avatar
      some_bih
      Icon for Community Champion rankCommunity Champion
      3 years ago

      Hi miracle2023 ok for negative.

      Failing Due is Due based on deadline date. - Explain more / what should be calculation logic.

      If it is easier to you in file (new one) update data as is your input and expected output just to be more efficient with questions.

       

      • miracle2023's avatar
        miracle2023
        Icon for Helper I rankHelper I
        3 years ago

        If I have 2 cases with deadline in October 2023, then I'll have 2 Falling Due in October. It is basically what my measures calculate (due in future and current due).

        Sorry I think I had to rename it for simplicity.