Solved

Select specific months

  • 28 July 2023
  • 1 reply
  • 392 views

Badge +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

View original

1 reply

Userlevel 4
Badge +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 

 

Reply