Forum Discussion
Comparing data corresponding to two date values where date is in single column
Hi This is my main table
| Publication date | | | Project name | | | Start date | | | end date | |
| 14-03-2024 | A | 14-06-2024 | 18-07-2025 |
| 20-05-2024 | A | 15-07-2024 | 18-07-2025 |
| 08-09-2024 | B | 15-07-2024 | 31-12-2024 |
| 06-07-2024 | A | 15-07-2024 | 16-08-2025 |
I have the publication date I want the user to select 2 publication dates which means I need to create 2 filters from the publication date so for example when filter 1 is selected= 14-03-2024 and filter 2 = is 20-05-2024
I need this as an output that shows the date shift of the start and end date of the project in comparison to filter 1 and filter 2 values
| Project name | | | planned start date | | | planned end date | | | 14-03-2024 | | | actual start date | | | actual end date | | | 20-05-2024 | |
| A | 14-06-2024 | 18-07-2025 | 399 | 15-07-2024 | 18-07-2025 | 368 |
how can we achieve this in powerbi
HI Tomar,
You can create a new date table as source of slicer and write a measure formula to extract the selected range and apply filter on visual level filter. Then you can use raw table field to create a matrix visual display the results.
Regards,
Xiaoxin Sheng
2 Replies
Please provide a more detailed explanation of what you are aiming to achieve. What have you tried and where are you stuck?
HI Tomar,
You can create a new date table as source of slicer and write a measure formula to extract the selected range and apply filter on visual level filter. Then you can use raw table field to create a matrix visual display the results.
Regards,
Xiaoxin Sheng
