Calculate if field = field-10

[Anonymous]

Hi there,

I am new to PowerBI and cannot make sense of the "CALCULATE" formula.

I am trying to calculate the salesvalues from a different fiscal quarter (fiscal quarter are not dates so all the dates related functions are not possible here).

the data looks like:

FQuarter  Amount

20201    $23,456

20202     $22,555

20203     $23,666

20204     $24,777

20211     $25,888

I am trying to do something like : CALCULATE(SUM(Amount), FQuarter=FQuarter-10).

I am probably using the wrong calculation here.

Has anyone got an idea please?

Thanks,

Alex

[amitchandak]

@Anonymous , Create a new table with FQuarter , year, and other required columns, say date.

Then create a rank on FQuarter 

a new column

Qtr Rank = RANKX(all('Date'),'Date'[FQuarter ],,ASC,Dense)

measure examples 
This Qtr = CALCULATE(sum('order'[Qty]), FILTER(ALL('Date'),'Date'[Qtr Rank]=max('Date'[Qtr Rank])))
Last Qtr = CALCULATE(sum('order'[Qty]), FILTER(ALL('Date'),'Date'[Qtr Rank]=max('Date'[Qtr Rank])-1))

10 qtr behind

Last Qtr = CALCULATE(sum('order'[Qty]), FILTER(ALL('Date'),'Date'[Qtr Rank]=max('Date'[Qtr Rank])-10))

Power BI — Qtr on Qtr with or Without Time Intelligence
https://medium.com/@amitchandak.1978/power-bi-qtd-questions-time-intelligence-2-5-d842063da839
https://www.youtube.com/watch?v=8-TlVx7P0A0