Need help sorting work by start, end

[Flexx]

Hello, 

I'm a very new user and need some help.  I have a data set with a request number, start date, and end date.

I would like to show how many of these requests start, end, or have the same start and end - based on date selected in slicer.

I"m not sure how to do that.  Any help would be greatly appreciated.  I've serached this forum for something that might help, either I was searching for the wrong thing or this question has not been answered before.

thanks.

[mangaus1111]

Hi @Flexx ,

do you want to know how many requests start and end the same day? Sorr, but I want to be sure what is your expected result

[Flexx]

Not sure what happened there.  thank you for your response.

im looking for three measures

1.  how many requests start

2. how many requests end

3. how many requests start and end on the same day.

i need to display these measures when selecting a date from a slicer.

[mangaus1111 · Accepted solution]

Hi @Flexx ,

see my pbi file. I hope it is ok.

https://1drv.ms/u/s!Aj45jbu0mDVJi2KgHLnLmtYddNES?e=gH8zvw

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Flexx]

@mangaus1111 , Thank you.  this works !

[daXtreme]

Data in the form of a picture is not suitable. Please give us text data that we can at least copy. Best would be to give a link to a file with data. Such a file would reside on a shared drive, like Google Drive, OneDrive... Don't forget to grant access rights if you decide to do this. THanks.

[Flexx]

New to this forum too, here is a link to the data .

Sample data