data support in power bi

[seenavinu]

Dear team,

I am not an expert in power bi, but learning on the go. I have imported excel workbook with multiple flight numbers with multiple start and end dates. Is there an easy calculation to see the flight data only based on the dates specified.

For e.g Flight no. 00001 I start date: 20/11/2002 I end date:13/12/2002 I start date: 16/12/2002 I end date: nil (this can go on). In this scenario, I would like to see the flight details on my power bi dashbaord only based on these specified start and end dates. 

Hope I am clear. Appreciate any support on this. Please let me know if you need more details to understand better.

Many thanks,

[JoeBarry]

Hi @seenavinu 

First of all, the data for what you want to achieve isn't in the correct format. The Data should be like below 

Flight No	StartDate	EndDate
1	11.01.2022	25.06.2022
1	25.07.2022
2	11.02.2023	11.04.2023
2	11.05.2023
3	05.08.2022	09/19/2022
3	11.10.2022

Is the data in the excel converted to a Pivot table? If yes, then import the tab in Excel instead that the Piviot table is using.

After this has been done, you have a couple of options. You can create two filters one for Start and one for End date, depending on what you want to filter on or

you will need to create a Date Table https://learn.microsoft.com/en-us/power-bi/guidance/model-date-tables and this where you need to make a decision, you can only filter on one date, so either Start or End. Using the date table will allow you to create measures like YTD, QTD, MTD...

Thanks

Joe

[seenavinu]

Thanks a lot, Joe. I am going to try this. I will definitely get back if I am stuck.