QoQ Calculation for Fiscal Quarter

hi, Anonymous

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

Hi Lin,

I tried your solution again, and it worked.

Thank youuuuuuuuuuuuuuuuuuu so muchhhhhhhhhhhhh.

Now other issue is apple to apple comparison, if in current quarter only 6 weeks have passed so wish to compare this with last quarter with 6 weeks data only.....please help me again.......

Regards

Rohit