Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi All,
I have used the below calculation to get the lastest churn lost for my data.
Now I need to get the last quarter churn lost but my calculations are not working.
Any help in this? I have Fiscal quarter in my dataset
Solved! Go to Solution.
Hi @Himanshu_1306 ,
This is my test table:
Please create a measure like below shown:
Last Quarter Churn Lost = CALCULATE([Latest Churn Lost],FILTER('Table','Table'[Fascial Quarter] = QUARTER(TODAY()) && YEAR('Table'[Fascial year month]) = YEAR(TODAY()) - 1))
You will get the last quarter churn lost:
Best regards,
Yadong Fang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Himanshu_1306 ,
This is my test table:
Please create a measure like below shown:
Last Quarter Churn Lost = CALCULATE([Latest Churn Lost],FILTER('Table','Table'[Fascial Quarter] = QUARTER(TODAY()) && YEAR('Table'[Fascial year month]) = YEAR(TODAY()) - 1))
You will get the last quarter churn lost:
Best regards,
Yadong Fang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.