Hello All,
Thank you for reading my question, first of all.
I have a data with attached columns in screenshot.
I would like to have below column as extract by applying filter:
Department
Previous Quarter: Q3_CY (As of today)
Definition of Previous Quarter:
This working is performed quarterly in April, July, October and January
(Since I am creating a workflow for the first time, I am standing in December now)
So, previous quarter means:
April: Q1_CY
July: Q2_CY
October: Q3_CY
January:Q4_CY
@ankush-agrawal , here is my solution if this is want you needed. You can dynamically select columns using dynamic select tool and specify the formula as per your conditions.
Returns a previous quarter. ... the Date column is often used to define relationships with other tables, to be easily used in CALCULATE as a filter. Live IQ Subway Mobile