Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Good day All,
Im progressing in my project and now I have issue with setting KPI targets. Reason is that my report is a little complex and I need extra effrot to find solution:
My example data table is like that:
DATE OF REPORT | Ship Name | Conditional Column (Target Date) |
1-Jan-21 | AA | Jan-21 |
2-Jan-21 | BB | Jan-21 |
3-Jan-21 | CC | Jan-21 |
4-Jan-21 | EE | Jan-21 |
3-Feb-21 | XX | Feb-21 |
4-Feb-21 | ZZ | Feb-21 |
5-Feb-21 | WW | Feb-21 |
6-Feb-21 | DD | Feb-21 |
at the moment it has 84 lines and growing on daily basis. Each line is submitted XLS file with data (84 reports). With help of comunity I have created follwoing measure to see how many reports I had by end of each target date:
Thnaks a lot
A KPI goal means you need to know what "good" represents. It is not clear in your scenario what is considered "good".
User | Count |
---|---|
25 | |
12 | |
8 | |
6 | |
6 |
User | Count |
---|---|
26 | |
12 | |
11 | |
9 | |
6 |