Financial 13 periods, how to get previous period sales using time intelligence

[Anonymous]

Hi,

We have 3,3,3,4 calendar with 13 periods.

Sales are reported on periodic level.

I have connected fact table Sales and Date table via 'starting day of the period' connects to 'day' in Date table.

I have index number for periods like '2017 Period 1' is '1' , .. ,  '2017 Period 12' is '12' and '2017 Period 13' is '13',

'2018 Period 1' is '14' , .. ,  '2018 Period 12' is '25' and '2018 Period 13' is '26'.

What I would like to know is, how to get sales from the previous fiscal period?

We have now selected 'Period 12', that is from 4.11. to 1.12.

How do I see sales in 'Period 11', that is from 7.10. to 3.11?

And how do I see sales in 'Period 11' a year ago?

Thank you!

[v-chuncz-msft · Accepted solution]

@Anonymous,

Try using CALCULATE Function to change the context.

• https://community.powerbi.com/t5/Desktop/Year-on-year-for-previous-reporting-period/m-p/326661#M1457...
• https://www.sqlbi.com/articles/filter-arguments-in-calculate/