Curbal posted a video showing DAX to calculate sales this month to day and compare to the prior month to day. Today is May 18, compare sales for May 1-18 to April 1-18.

These DAX commands were used:

  • CALCULATE
  • DATEADD
  • FILTER
  • DATESMTD
  • TODAY