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.
Dear All,
I am not able to find a solution to following issue
I have a table with multiple columns - with ID, date, description, ...
I need to calculate the total distinct IDs - for only the earliest occurance by date - so I can visualize it per year/month based only on the earliest occurance.
Now the column chart gets mixed up with the dates.
ID | Date | Description | ... |
1 | 11/11/2023 | Not relevant | |
1 | 12/11/2023 | ||
2 | 10/11/2023 | ||
2 | 11/11/2023 | ||
3 | 5/11/2023 | ||
4 | 6/11/2023 |
example graph
Hope it is a bit clear.
Kind regards
The earliest date the ID occurs in the table
hi @Cocieto06 ,
Could you enrich your sample data to well reflect your case and with the corresponding expected result?
Hello
Table1
ID | Operation | Timestamp | Description ... |
1 | start | 11/11/2023 | |
1 | stop | 11/11/2023 | |
1 | start | 12/11/2023 | |
2 | start | 14/11/2023 | |
2 | stop | 15/11/2023 | |
3 | start | 20/11/2023 | |
3 | stop | 21/11/2023 | |
3 | start | 22/11/2023 | |
4 | start | 15/11/2023 | |
4 | stop | 16/11/2023 |
result
ID | operation | Time |
1 | Start | 11/11/2023 |
2 | start | 14/11/2023 |
3 | start | 20/11/2023 |
4 | start | 15/11/2023 |
COUNT total IDs |
Afterwards
Use count IDs in graph in y-axis
and use timestamps of only table 2 for X-axis (linked with date table to show by year/month)
the one from table two will all be seen in the 2023/11 column (block of 4 - since total is 4 units)
so i have these ID with that earliest event - this date is related to a data table with Year/month column. But I am not able to Visualise it because indeed units that start in oktober are seen in November and vice versa
User | Count |
---|---|
22 | |
11 | |
8 | |
6 | |
6 |
User | Count |
---|---|
25 | |
12 | |
11 | |
8 | |
6 |