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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
Cbtpuni
New Member

Date Slicer based on Start Date and End Date from Excel List

Hello everyone,

 

I have a list with items to track status and time.

I have to visualize my Power Bi report based on Closed status with a closed date. Based on Business month the start and End date of each month is diffrent to the normal calender.

I create a excel Table with 3 Columns. Column 1 contains the name of the month, column 2 the start date of the month and column 3 the End date.This table is loaded from an online excel list,where the dates will be updated in the future.

 

Now i want to Integrate the month in column 1 into a date slicer (Dropdown). All items with closed date between the start and End date of column 2 & 3 linked do the name of month in column 1 should be visble.

 

I don't get it work right now.

Also possible would be a measure for the dates. A Month End on the last friday inside the month and the New month starts the das After until reaching the last friday of that month.

 

Thank you in Advance,

 

Warm regards.

2 REPLIES 2
technolog
Super User
Super User

I hope this message finds you well. I've noticed that this solution remain unresolved. If any of you have managed to find a resolution to the issue, I kindly request that you share your solution for the benefit of the entire community. Alternatively, if you're still facing challenges, please do let us know as well.

Your insights and updates will greatly assist others who might be encountering the same challenge.

v-shex-msft
Community Support
Community Support

Hi @Cbtpuni ,

Can you please share a pbix or some dummy data that keep the raw data structure with expected results? It should help us clarify your scenario and test to coding formula.

How to Get Your Question Answered Quickly  

BTW, you can also take a look at the following blog about start, end date range analysis if helps:

Before You Post, Read This: start, end date 

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

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

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.