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

[Cbtpuni]

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.

[technolog]

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]

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