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.
Hi everyone,
I have items with statuses, and every item could change its status over time. But when I select status in table, it selects all items which had or have this status over time. How can I select only last value? I've tried to add visual level filter, but it didn't accept date field.
Example of how problem looks:
item_name had statuses status_1, status_2 but currently has status_3
item_name_1 had status_1, currently has status_2
item_name_2 had status_2, currently has status_1
When I click on status_1, it selects all three item names, but I want to select only status_1.
Regards,
Yerkhan
Hi @ysapiyev
Maybe you can uuse the Max function
If(YourDateColumn=MAX(YourDateColumn);Status)
Something like that
Else if you don't understand
Can you please provide us a sample of your data ?
- Quentin
Did you try to use the 'Last value' filter ? There is Top-N filtering and you can filter from top or bottom. Maybe use it with your date ?
- Quentin
I've tried this, when I use top or bottom 1 by date, it shows me empty table.
Regarding sample data, it has many connections inside of database, I'm not sure I can correctly extract this data.
Regards,
Yerkhan
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 |
---|---|
109 | |
96 | |
77 | |
66 | |
53 |
User | Count |
---|---|
144 | |
105 | |
102 | |
89 | |
63 |