Creating a measure for same day last month

[roycechan]

Hi folks, I’m looking to build a measure to sum a number e.g. outstanding balance for the same day last month. I’m able to do so currently with a custom expression for a table calculation.

add_months(-1, ${business_date})

e.g. if business_date is 2022-11-03, the measure should sum the outstanding balance for the same day one month ago i.e. 2022-10-03.  

I’m looking to create a measure in LookML so that all business users will be able to query it. Any advice on how this should look like?