Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello
We have categorized open projects into age buckets like 0-30 days, 30-60 days and so on
Users want to know which project moved from one aging category to another and be notified by alert
To begin with I can create a count of projects in each category which will give me an indication of when projects move out of one category to another but how do I identify which projects moved .
As always thanks for taking time out to help novices like me
Regards
Hi @svishwanathan,
Could you please provide a sample PBIX? At least the sample data in the TEXT mode. The solution all depends on the data.
I want to make this more clear. One project A is in 0 - 30 group at first. When the days of A become 31 then alert. Nothing will happen with days 32, 33 ... Is this the scenario?
Best Regards!
Dale
Yes
Your understanding is perfect. I want to set a dashboard to immediately alert users when there is movement in category. I believe I can set an alert for everytime there is a change in the data but not sure if it will be able to identify which invoice moved
Swati
Sorry I dont see how I can upload a document
Hi @svishwanathan,
You can share the document through GoogleDrive, Dropbox, etc. Then post a link here.
Best Regards!
Dale
User | Count |
---|---|
98 | |
90 | |
82 | |
73 | |
67 |
User | Count |
---|---|
115 | |
102 | |
98 | |
71 | |
67 |