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...
some_bih's avatar
some_bih
Icon for Community Champion rankCommunity Champion
3 years ago

Hi miracle2023 I would say, the best would be to share example file with expected output.

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

    I provide screenshot because no any sharefile service is availible for me from my work computer.

    I'm trying to replicate this Excel in PowerBI. 

     

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

      Hi miracle2023 pbi file is need due to context transition and overall model. Share when it is available, with example for expected outpu.

  • 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.