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,
I have realized a measure that count how many days occurs from start and end date.
The problem is that it does not work for everi start-end periods and I can't know why.
I have a calendar with all the year days.
Thank you for help.
Hi @lfrigione ,
I think you want to count rows in your calendar table to get the count of days. But I don’t understand the formula of “From” and “To”.
Do you think there is a problem with the value returned by your measure or do you think that the date range of the data in the table is inconsistent with that selected in the slicer? Some sample data can be provided if allowed.
Best Regards,
Eads
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi, thank you for reply @v-eachen-msft.
I think that there is a problem with the value returned from the formula.
The from and to fields represents a start and an end period date.
The calendar is necessary to filter analisis period for specifics.
I need to calculate the sum of the days.
In this exaple the total value must be 40 (there are other hidden rows in the table, we consider only visibles).
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 |
---|---|
112 | |
99 | |
73 | |
72 | |
49 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |