Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello guys,
How are you doing?
I'm currently working on a project to determine the activation of clients based on the date of their last purchase.
Each client can have multiple contracts made in different dates, so we determined as follows:
- Last contract was on 2021 is critical;
- Last contract from 01/01/2022 until 6 months before today needs atention;
- Last contract 6 month til today is OK.
I've used this formula to check their activity status:
Atividade = IF(Fato_Comex_Movimento[Ano_PI]<=2021,"Crítico",IF(MONTH(TODAY())-Fato_Comex_Movimento[Mês PI]<=6,"OK","Atenção"))
And the result was this matrix:
But as you can see in the image, the last contract of the client 4 was on 23/03/2022 so it should be "Atention", not "Critical"
So the expected result should be like this:
If I change to "First Ativididade" instead of "Last Atividade" the matrix becomes even worse...
How can I fix this?
At the end I would need to inform how many are OK, Atention or Critical. But I think I can do that using filters on the cards for the dashboard.
Solved! Go to Solution.
@Comex_Palmali , refer if my blog on the same can help
https://amitchandak.medium.com/power-bi-get-the-last-latest-value-of-a-category-d0cf2fcf92d0
It was exactly what I needed!
You have solved a lot of my problems here!
Thank you!
@Comex_Palmali , refer if my blog on the same can help
https://amitchandak.medium.com/power-bi-get-the-last-latest-value-of-a-category-d0cf2fcf92d0