Forum Discussion
Inventory Turnover by Quarter
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
2 Replies
- amitchandak
Super User
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-bd52912a5bd4
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
Helper I
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