Show all entries of a table with start and end date based

[Anonymous]

Hi all,

I am looking for a solution not to calculate but to show all entries of a table that have an start date before and an end date after a selected date.

I have created a simple example as per screenshot and PBIX file below:

http://roggenmoor.de/PowerBi/DashboardScreenshot.jpg

http://roggenmoor.de/PowerBi/filter_twodatecolumns.pbix

In that example I would like to select the 07/01 and want to have the event starting on the 6/01 and ending on the 08/01 shown in the table below.

Thanks for your help

BR

Andreas

[Jihwan_Kim · Accepted solution]

Hi, @Anonymous 

Please correct me if I wrongly understood your question.

I have attached the sample pbix file's link down below.

I made an inactive relationship for both the start date and the end ate - date table.

I created the measure like below, and inserted into the visual filter.

truefalse measure =
CALCULATE (
COUNTROWS ( event ),
FILTER (
event,
event[start_date] <= SELECTEDVALUE ( 'date'[Date] )
&& event[end_date] >= SELECTEDVALUE ( 'date'[Date] )
)
)

https://www.dropbox.com/s/1aubishhz9w5n23/filter_twodatecolumns.pbix?dl=0 

Hi, My name is Jihwan Kim.

If this post helps, then please consider accept it as the solution to help other members find it faster.

[Anonymous]

Hi Jihwan,

That looks pretty good. Thank you so much.

BR

Andreas

[Ashish_Mathur]

Hi,

This could be a start.  Download the PBI file from here.

Hope this helps.

[Anonymous]

Thanks Ashish as well!

[Ashish_Mathur]

You are welcome.

[Jihwan_Kim]

Hi, @Anonymous 

I am not sure if it is only me or not, but I cannot open your linked pbix file.

Is it OK with you to share it via dropbox, onedrive or google drive?

thank you.

[Anonymous]

Hopefully this works:

https://encome-my.sharepoint.com/:u:/g/personal/andreas_meyer_en-come_com/EZXoFKvoFeRBp_Yk7mDdbakBxG...