Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
seenavinu
Regular Visitor

data support in power bi

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,

seenavinu_0-1692774550178.png

 

 

2 REPLIES 2
JoeBarry
Solution Sage
Solution Sage

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 NoStartDateEndDate
111.01.202225.06.2022
125.07.2022 
211.02.202311.04.2023
211.05.2023 
305.08.202209/19/2022
311.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.

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

Check out the February 2024 Power BI update to learn about new features.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.