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 community,
I have a table with a counter on the number of vehicles and the date, and I would like to create the counting up until today, if possible. Say I have:
Date | Brand | Country | Fleet name | Onboarding | Unboarding | Total |
2022-04-22 | Bus | SWE | Swe2 | 1 | 0 | 1 |
2022-04-30 | Bus | SWE | Swe2 | 2 | 0 | 3 |
2022-05-12 | Bus | SWE | Swe2 | 0 | 1 | 2 |
2022-04-10 | Bus | BEL | BEL1 | 3 | 0 | 3 |
2022-04-15 | Bus | BEL | BEL1 | 1 | 0 | 4 |
2022-04-23 | Bus | BEL | BEL1 | 5 | 0 | 9 |
2022-05-01 | Bus | NLD | NLD2 | 6 | 0 | 6 |
2022-05-17 | Bus | NLD | NLD2 | 0 | 2 | 4 |
I would like to replicate the dates in between, so I could show the evolution over time.
Hope it makes sense. Thanks for any help 🙂
Wish you a lovely day!
That looks good, I tried to do it with a line chart but I couldn't see the evolution, it looked like:
Is it possible to replicate it up until today? I tried modifying your measure for the current date, but didn't change.
Thanks again @tamerj1
Only change the last date of the date table to today like
CALENDAR ( MIN ( 'Table'[Date] ), TODAY ( ) )
I did, but it doesn't seem to apply :S.
Ideally I want a line chart, and it looks like:
My calendar table:
Hello, yes! For example, for the first fleet Swe2, it would be:
Date | Brand | Country | Fleet Name | Onboarding | Unboarding | Total |
2022-04-22 | Bus | SWE | Swe2 | 1 | 0 | 1 |
2022-04-23 | Bus | SWE | Swe2 | 0 | 0 | 1 |
2022-04-24 | Bus | SWE | Swe2 | 0 | 0 | 1 |
2022-04-25 | Bus | SWE | Swe2 | 0 | 0 | 1 |
2022-04-26 | Bus | SWE | Swe2 | 0 | 0 | 1 |
2022-04-27 | Bus | SWE | Swe2 | 0 | 0 | 1 |
2022-04-28 | Bus | SWE | Swe2 | 0 | 0 | 1 |
2022-04-29 | Bus | SWE | Swe2 | 0 | 0 | 1 |
2022-04-30 | Bus | SWE | Swe2 | 2 | 0 | 3 |
I hope it makes sense, it's to make a cumulative over time, if that makes more sense.
Thanks for your time @KeyurPatel14
Editing after @tamerj1 answer, I would like the totals to replicate up until today 🙂
I must be doing something wrong, because I don't get the same results:
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 |
---|---|
47 | |
24 | |
20 | |
15 | |
13 |
User | Count |
---|---|
51 | |
46 | |
39 | |
19 | |
19 |