Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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?
Solved! Go to 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.
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
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.
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.
User | Count |
---|---|
98 | |
90 | |
78 | |
71 | |
64 |
User | Count |
---|---|
112 | |
96 | |
95 | |
67 | |
65 |