A user wants to calculate a running total of sales by date. Which DAX function is most appropriate?

Power BI Medium

Power BI — Medium

A user wants to calculate a running total of sales by date. Which DAX function is most appropriate?

Key points

  • TOTALYTD() handles year-to-date calculations naturally
  • SUMX() is better suited for iterating over tables
  • CALCULATE() is more versatile but requires additional context
  • CUMULATE() is not the best fit for this specific scenario

Ready to go further?

Related questions