Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi All,
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
Thanks!
Solved! Go to Solution.
Hi,
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: =
SUMX (
Data,
CALCULATE (
COUNTROWS (
FILTER (
'Calendar',
'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.
Hi,
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: =
SUMX (
Data,
CALCULATE (
COUNTROWS (
FILTER (
'Calendar',
'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.
Hi,
what if the duration in decimal places? and I would like the decimal place count in start date.
Thanks!
Hi,
I am not sure if I understood your question correctly, but please check the attached file.
Thank you.
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.
Hi, is there anyway that can do this without creating another calculated table? I worry there will be performance issue.
Hi,
Thank you for your message.
Please check the attached file.
I tried to add two more measures and created a table visualization by only using two measures, and without using a physical-calculated-table.
Please kindly check if the result shows correct numbers or not.
Thank you.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
43 | |
21 | |
20 | |
15 | |
13 |
User | Count |
---|---|
45 | |
41 | |
39 | |
19 | |
19 |