Inventory Turnover by Quarter

[moatazezat]

For Financial ratios analysis 

How can I calculate Average Balance Sheet Items?

(Last Q Current Year + Last Q pervious year)÷2=Average

many thanks

Moataz

[amitchandak]

@moatazezat , Assume you already have a measure not using time intelligence M

then try like

2 Qtr Avg = CALCULATE(AverageX(Values('Date'[Quarter Year]),[M1])
,DATESINPERIOD('Date'[Date ],MAX('Date'[Date ]),-2,Quarter ))

Why Time Intelligence Fails - Powerbi 5 Savior Steps for TI :https://youtu.be/OBf0rjpp5Hw
https://amitchandak.medium.com/power-bi-5-key-points-to-make-time-intelligence-successful-bd52912a5b...
To get the best of the time intelligence function. Make sure you have a date calendar and it has been marked as the date in model view. Also, join it with the date column of your fact/s. Refer :radacad sqlbi My Video Series Appreciate your Kudos.

[moatazezat]

Thanks for the reply,

I used the time intelligence average but the Average which appears is during the year, 

I need (previous year last Q + current Year last Q )/2

Regards,

Moataz