I have a data set with a few thousand line items. In this, there are 2 columns, a start date, and an end date. I am looking for a way to determine if an item was standing during a certain date. This is easy to do with a simple if statement, but the problem Im having is that I want to be able to filter it at the visual level by any date, selected by the user.
I have [ActualBuildDate] and [ActualDismantleDate] Where [ActualBuildDate] will aways have a date, and [ActualDismantleDate] will alway be after [ActualBuildDate] or blank (Still standing).
If I select January 2020, I want to see every item that was standing during January 2020.
I have a Calender table set up using this code
@MattScruggs ,Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
Tag start date end date standing
1 | 10/1/2020 | 10/5/2020 | complete |
2 | 10/2/2020 | 10/6/2020 | complete |
3 | 10/3/2020 | 10/7/2020 | complete |
4 | 10/4/2020 | 10/8/2020 | complete |
5 | 10/5/2020 | standing | |
6 | 10/6/2020 | standing | |
7 | 11/5/2020 | 11/6/2020 | complete |
8 | 11/6/2020 | 11/7/2020 | complete |
9 | 11/7/2020 | 11/9/2020 | complete |
10 | 11/8/2020 | standing |
This would be a simplified version of the data.
Calendar table is separate and is the range of dates from earlest to latest in the previous table (10/1/2020 to 11/9/2020, whether the latest date is in the start or end column.)
Power BI release plans for 2023 release wave 1 describes all new features releasing from April 2023 through September 2023.
Make sure you register today for the Power BI Summit 2023. Don't miss all of the great sessions and speakers!
Join the biggest FREE Business Applications Event in LATAM this February.
User | Count |
---|---|
94 | |
82 | |
42 | |
32 | |
28 |
User | Count |
---|---|
130 | |
95 | |
84 | |
46 | |
40 |