The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends September 15. Request your voucher.
Hello,
I want to know how many boxes I totally cleared by year from the start and visualize this.
This is how the raw data looks ( I added a empty column for the readability):
Box nr | Action date | |
764-5289 | 1-1-1907 | |
764-2894 | 3-2-2017 | |
764-2288 | 6-7-2017 | |
764-2874 | 31-8-2017 | |
764-3289 | 18-8-2018 | |
764-2328 | 18-10-2018 | |
764-5288 | 22-2-2019 | |
764-2866 | 18-4-2019 | |
764-2825 | 25-5-2019 | |
764-2826 | 25-5-2019 | |
764-2815 | 23-7-2019 | |
764-3428 | 23-8-2019 | |
764-3283 | 6-9-2019 | |
764-3284 | 6-9-2019 | |
764-2870 | 14-2-2020 | |
764-2841 | 17-4-2020 | |
764-2285 | 30-1-2021 | |
764-2873 | 7-2-2021 |
The information I have:
But the difference is now a simple subtraction grand total - diffence a year. But what I want to know is not the boxes cleared out at one year but also the years before. Like the table below.
How can I achieve this?
I found this which looks like what I'm looking for. But since I made the calculations with measures ( I only have dates and box number in my data) I can't make a calculated column.
At the end it has to look something like this (with the right order of years.)
Please provide sample data (with sensitive information removed) that covers your issue or question completely, in a usable format (not as a screenshot).
https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...
Please show the expected outcome based on the sample data you provided.
https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...
User | Count |
---|---|
15 | |
12 | |
7 | |
6 | |
5 |
User | Count |
---|---|
24 | |
20 | |
12 | |
9 | |
7 |