0

I need help to get a dynamic expression for the previous month (December 2022) compared to the current year's month, January 2023.

Perhaps the attached might provide some more clarity.

enter image description here

Stefan Stoichev
  • 4,615
  • 3
  • 31
  • 51
LoKi_Asterix
  • 7
  • 3

1 Answers1

1

Depends on your data format a bit but in general you should be able to use something like:

= sum( {< Month = {"$(=MonthStart(AddMonths(Today(), - 1)))"} >} Sales)

The set analysis will filter the Sales and will be sum only values for which Month is the month start of the previous month (based on Today() function result)

Stefan Stoichev
  • 4,615
  • 3
  • 31
  • 51