Current Month, previous month, last 3 months average

[pantelis]

Hi,

I have a table and I want to calculate the below.
how to check if the date of the appointment is in current month or previous month or in the last 3 months (excluding the current)?

[Giridhar.Prabhu]

Hi @pantelis

You can create calculate fields for the three measures ( Current Month Appts, Previous Month Appts, Average of Last 3 months ) using the date functions in QuickSight.

The following Article has detailed information to help you create these kinds of calculations.

Period Over Period and Other Date Comparison Calculations (YoY, MoM, YTD, Rolling 90 days, etc)

Hi @lbl You can use the Relative Dates on the parameters (may need to make more parameters) to automatically default to a given date that represents the time period, and can use those in your table headers. It’s not as flexible as being able to write your own calculated logic, but you should be able to get most time periods represented using this (prefix each with ‘Month of’ or ‘Week of’, then put the parameter there… [image] [image]

Regards,
Giri

[pantelis]

Thanks @Giridhar.Prabhu . I found what I wanted in the article