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?
Solved! Go to Solution.
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?
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.