Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hello,
After solving this problem, my final goal will be to create a line chart, of the accumulated costs of each project, but instead of in X-Axis being in one with the dates of the projects, it will be in a percentage line. It will be to see how much a project spent at 25%, 50%, etc, of duration.
Table image:
I am a beginner in Power Bi, and I think it may be easy to solve, but I needed to find a way to classify the first date of accounting entry as 0% and the last as 100%, for each of the projects of the query.
Warning: There are accounting posting dates that happened on the same day.
I have attached a project with an example of how I have the Accounting Entries Table, which in my Data Model, is linked to a Date Table.
Hi @franciscogsp ,
The link you provided shows "Hmmm… can't reach this page". Can you reshare it again?
Looking forward to your reply.
Best Regards,
Henry
Hello,
Can you try this one: https://wetransfer.com/downloads/9422169a06344006b9207f01641d015220221201223348/956cb1
Thanks
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
64 |
User | Count |
---|---|
135 | |
120 | |
101 | |
71 | |
61 |