How to calculate worklog Date and start Of the Month

Questions & Answers
1

Hi Team,
I have to apply filter where worklogDate() > startOfMonth(). I have tried many ways but not able to get.

Thanks in Advance.

2

Hi @KRANTIK_KALE,

You are probably looking for the time spent within the current month.
You might use the calculated member “Current month” in the page filter.
You might read more about calculated members in the Time dimension here - Calculated members in Time dimension.

You might create it with the following expression if you do not have it yet.

Aggregate({
  [Time].[Month].CurrentDateMember
})

The measure “Hours spent” will then return the hours logged for the current month.

Regards,
Oskars /support@eazyBI.com

3

Thanks @oskars.laganovskis.