cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
SivaMani Senior Member
Senior Member

DAX: Calculate value 6 months back

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?

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
SivaMani Senior Member
Senior Member

Re: DAX: Calculate value 6 months back

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. 

 

 

3 REPLIES 3
Community Support Team
Community Support Team

Re: DAX: Calculate value 6 months back

Hi @SivaMani,

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

1.PNG

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

1.PNG

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

 

Regards,

Daniel He

Community Support Team _ Daniel He
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
SivaMani Senior Member
Senior Member

Re: DAX: Calculate value 6 months back

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. 

 

 

SivaMani Senior Member
Senior Member

Re: DAX: Calculate value 6 months back

@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.