Forum Discussion

SuzanneSte's avatar
SuzanneSte
Frequent Visitor
3 years ago

Need assistance with MTD calculation

I have been through previous requests, but cannot find an answer I can get to work correctly in those responses. 

I am trying to count the number of events until today, but this is not taking the current date into consideration

Would appreciate any guidance

MTD Start =
    CALCULATE(
        COUNT('events-export'[Invitee Email]),
           DATESMTD('events-export'[Start Date].[Date]), DateTable[Date])

3 Replies