QoQ Calculation for Fiscal Quarter

[rohit_sharma2]

Hi, I have fiscal Year/quarter starting from Feb, and in following format : 2018Q1 2018Q2 please help me on QoQ calculation, previous quarter and dateadd function doesnt work on custom calendar which i created according to my organization needs......it should display in following format: Quarer Sales Last Quarter 2018Q1 100 2018Q2 200 100 2018Q3 300 200

[v-lili6-msft · Accepted solution]

hi, @rohit_sharma2

Does your custom calendar have no date column, just like this:

If so, you could try this way as below:

Step1:

Add a rank column for fiscal Year/quarter

rank = RANKX('calendar','calendar'[ fiscal Year/quarter],,ASC )

Note: You could add the rank column for the custom calendar according to the custom.

Step2:

Create a relationship between data table and custom calendar table

Step3:

Use this formula to add a measure

Measure = CALCULATE(SUM('Table'[value]), FILTER(ALL('calendar'),'calendar'[rank]=MAX('calendar'[rank])-1))

Result:

and here is pbix file, please try it.

If it is not your case, please share sample pbix file or some data sample and expected output. Do mask sensitive data before uploading

Best Regards,

Lin