Parallel Period giving Future dates

[Anonymous]

Hi, I am trying to compare the sales on monthly basis,

I am using the following DAX

Net Stock Value Calc =

CALCULATE(SUM(PartsStockSummary[NettStockValue]),

FILTER(PartsStockSummary, PartsStockSummary[StockDate] = MAX(PartsStockSummary[StockDate])))

Net Stock Monthly Change % =

VAR __BASELINE_VALUE = CALCULATE([Net Stock Value Calc], PARALLELPERIOD(Dates[Date], -1, MONTH))

VAR __VALUE_TO_COMPARE = [Net Stock Value Calc]

RETURN

DIVIDE(__VALUE_TO_COMPARE - __BASELINE_VALUE, __BASELINE_VALUE)

]

I don't the table to show the October data, could anybody please help me in this regard?

Regards,

Prime

[Greg_Deckler]

See if my Time Intelligence the Hard Way provides a different way of accomplishing what you are going for.

https://community.powerbi.com/t5/Quick-Measures-Gallery/Time-Intelligence-quot-The-Hard-Way-quot-TIT...