DAX: Calculate value 6 months back

[SivaMani]

Hi All,

I'm trying to calculate the amount that 6 months back. I used below measure,

CALCULATE(SUM(amt), PARALLELPERIOD(Date, -6, MONTH)

But it returns blank. However, It shows the correct date if I keep only PARALLELPERIOD(Date, -6, MONTH).

What's wrong here?

[v-danhe-msft]

Hi @SivaMani,

Based on my test, the first formula you have offered could work on my side:

And if I keep only PARALLELPERIOD('Table1'[Data], -6, MONTH), it will show error.

 Could you please offer your sample data to have a test if possible? 

Regards,

Daniel He

[SivaMani]

@v-danhe-msft,

Unfortunately, I can't share sample data. It is my client data.

The first measure works for me with SQL DW connection. 

I'm wondering what's wrong with BigQuery.

[SivaMani · Accepted solution]

Thanks for the response,@v-danhe-msft.

Seems the time intelligence DAX functions aren't working as expected. I have used FILTER to explicitly say the filter value and it works.