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 each month "next 16 months" will be changed like next 15/17 month or similar...? static value is always static, I min fix amount not like fix amount of september another for october...? Your model have many columns as you use 

USERELATIONSHIP(dimDate[Date]

As you have Date table for dynamic solution, please check formula for running total on link as guide / idea how to implement something which overlap year end.

https://www.sqlbi.com/articles/computing-running-totals-in-dax/ 

 

kudos appreciated

 

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

    Hi, 

    Thank you for your reply.

    I want to get predictions for next 16 months. So if current month is September, I'd expect them until January 2025. Static value is constant for all months and should not be changed. 

    I doubt that DATESYTD resolves my issue because the main problem is predicted overdues - I struggle to get them for future which change every month.