Calculate until date

[beaoliv123-_]

Hi there, I'd like to know what were my customers from the beggining until last month. How do I do this filtering?

Thanks 

[isabella]

Hi @beaoliv123-_ 

I did a local test,you can set filters like this:

Then you can create a measure to calculate the distinct count of customer before this month

customerCountBeforeThisMonth = CALCULATE( DISTINCTCOUNT('Table'[customer]),FILTER(ALL('Table'),[date]<DATE(2022,6,1)))

Best Regards,

Community Support Team _Isabella

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Hi, 

Not a lot of detail, but does this help you?

Value from start to EndOfLastMonth = 
CALCULATE(
    SUM(SalesTransactions[Amount]) // Sum amount
    ,'Calendar'[Date] <=EOMONTH(MAX('Calendar'[Date]),-1) //Filter for end of month
    )