Forum Discussion
data support in power bi
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
Thanks a lot, Joe. I am going to try this. I will definitely get back if I am stuck.