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.