Comparing data corresponding to two date values where date is in single column

[Tomar]

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

[Anonymous · Accepted solution]

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

[lbendlin]

Please provide a more detailed explanation of what you are aiming to achieve. What have you tried and where are you stuck?