I would like to count number of days fall on certain day (Sun, Mon, etc) providing StartDate and EndDate.
The following is the data structure:
I expect the output as following:
1) Filtered Date: 2022-08-01 to 2022-09-30:
2) Filterd Date: 2022-09-01 to 2022-09-10
Go to Solution.
I am not sure about the result that is shown in your sample, but please check the below picture and the attached pbix file.
It is for creating a measure.
Expected result measure: =
'Calendar'[Date] >= MAX ( Data[StartDate] )
&& 'Calendar'[Date] <= MAX ( Data[EndDate] )
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
View solution in original post
Click here to learn more about the September 2022 updates!
Mark your calendars and join us on Thursday, September 29 at 11a PDT for a great session with Ted Pattison!