Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Min & Max Value per Month on a Running Total - Performance issue

Hi,   In a cash flow report I need to show the dailly postition of the cash accounts; it's basically a runing total of all transactions. No particular problem with that, I use this mesaure to calc...
some_bih's avatar
some_bih
Icon for Community Champion rankCommunity Champion
3 years ago

Hi Anonymous again try with variable

Min monthly position  = 
 
VAR _selected_period = VALUES(CALENDAR[YEAR_MONTH])
VAR _result=
CALCULATE(
MINX (ALL(CALENDAR[DAY]),
[running total]),
_selected_period
)
RETURN _result
Anonymous's avatar
Anonymous
Not applicable
3 years ago

Unfortunately it doesn't make a significant difference to use a variable in the min monthly position 🙁

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

    Hi Anonymous I suggest to analyze it in "isolated scenario" meaning that you remove any other visuals in canvas / report and check timing, this way you figure out how other visuals affect your specific one. In addition, use DAX Studio to trace performance and accordingly eventually adjust code.

    Another, complex maybe approach would be to "move" amounts to Calendar / Date Table if it suits your need. This way as probably your Date / Calendar table is much much lowe concerning cardinality than your Fact table. Think about it.🙂

    Hope this help