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.
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
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 |
---|---|
112 | |
100 | |
76 | |
74 | |
49 |
User | Count |
---|---|
145 | |
108 | |
107 | |
89 | |
61 |