Forum Discussion
Helper IIICount Number of Rows - Based on Start Date
Hi,
I am not sure whether I understood your question correctly, but please check the below picture and the attached pbix file.
All measures are in the attached pbix file.
Super UserHi,
I am not sure how your data model looks like, but I suggest having a dim-calendar table like below.
Please check the below picture and the attached pbix file.
Employees count: =
IF (
HASONEVALUE ( 'Calendar'[Month & Year] ),
CALCULATE (
COUNTROWS ( Data ),
FILTER (
Data,
MIN ( 'Calendar'[Date] ) <= Data[dateEnd]
&& MAX ( 'Calendar'[Date] ) >= Data[dateBegin]
)
)
)
Helper IIIJihwan_Kim That worked!
Is there a way I can see the net difference between each month from month to month?
- Jihwan_Kim
Hi,
I am not sure whether I understood your question correctly, but please check the below picture and the attached pbix file.
All measures are in the attached pbix file.