Solved

Select specific months

+2

How do I select the first 3 months of each FY?

For ex:

Revenue [SELECT: Month.Quarter] gets me the revenue for each quarter. but now I want just Q1 in each FY. How do I do that?

icon

Best answer by abhilashsawla 28 July 2023, 20:48

Userlevel 4

+6

hi @Lester Chow

You have Revenue Metric and want to filter data of your Q1 Revenue from Revenue Metric.

Revenue Metric

For Q1 data from Revenue Metric

Apply following formula:

Revenue[Month.Quarter.'Quarter of Year'='Quarter of Year'."Q1"]

Hope, I have answered your question.

Thanks

Sign up