Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
97 | |
96 | |
81 | |
74 | |
66 |
User | Count |
---|---|
129 | |
106 | |
106 | |
86 | |
72 |