Average price of current year and previous year showing same.

[Varshi288]

Hi  All, 

I have a problem with the Dax formula to  calcuate avg TP  previous year iwth current year. Both values are showming same. I tried with two different formulas where the result is also same.

Avg TP = DIVIDE(sum(Data[TP $]), sum(Data[Qty]))

AVG TP PRY = CALCULATE([Avg TP],SAMEPERIODLASTYEAR(Period[Year_Month].[Date]))

Avg Price PrY = CALCULATE([Avg TP],PARALLELPERIOD(Period[Year_Month].[Date],-1,YEAR))

Note: My date table is have only date per month.

Any help in fine tuning the formula. Thanks in advance.

[amitchandak]

@Varshi288 , You need to use a date column along with a date table.

example

Year behind Sales = CALCULATE(SUM(Sales[Sales Amount]),dateadd('Date'[Date],-1,Year))
Year behind Sales = CALCULATE(SUM(Sales[Sales Amount]),SAMEPERIODLASTYEAR('Date'[Date]))
Year behind Sales = CALCULATE(SUM(Sales[Sales Amount]),previousyear('Date'[Date]))

refer by Time intelligence fails - https://youtu.be/OBf0rjpp5Hw

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.

[Varshi288]

Thanks for reply,

Yes I am using date column where I have only one date per moth in the data table sa well as date table.