Forum Discussion

moatazezat's avatar
moatazezat
Icon for Helper I rankHelper I
3 years ago

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
Need Help
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
3 years ago

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's avatar
moatazezat
Icon for Helper I rankHelper I
3 years ago

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