relative fiscal QTR

[Anonymous]

Hi guys,

I have created a relative date filter usings curbals video

https://www.youtube.com/watch?v=gGNxKluPFNw

Now i want to create on but for Quarter, the thing is PBI has QTRs set to jan to dec rather than November to October which is what  i need , so we get a table like this when aplying this formula 

Relative QTR = DATEDIFF(TODAY(),'Calendar'[Full Date],QUARTER)

month	qtr Fiscal quarter	qtr pbi
1	1	1
2	2	1
3	2	1
4	2	2
5	3	2
6	3	2
7	3	3
8	4	3
9	4	3
10	4	4
11	1	4
12	1	4

How can i set the Quarter to the range i want?

Thanks

[amitchandak · Accepted solution]

@Anonymous , did not get clear.

You can create a qtr of your choice  with help of this post -https://community.powerbi.com/t5/Community-Blog/Creating-Financial-Calendar-Decoding-Date-and-Calendar-1-5-Power/ba-p/1187441

Check-in in the regional setting does you have an option to set year.

also refer

Power BI — QTD Questions — Time Intelligence 2–5
https://medium.com/@amitchandak.1978/power-bi-qtd-questions-time-intelligence-2-5-d842063da839