Count based on a date condition

[Nickolay1]

Hi all,

I need to create a measure in a bar chart that will count number of batches which correspond to the current month in the column Next 3 months (pls see the file attached). The dimension is not Next 3 three months. Based on this example the result should be 3. I tried this expression: 

Count({<[Next 3 months]={monthstart(today())}>}[Batch Number])

Thanks!

[ogster1974]

something like

count(distinct {<[Date]={">$(=monthstart(today())) <$(=AddMonths(monthend(today()),3))"}>} [Batch number])

[vinieme12 · Accepted solution]

Month end has period_no, parameter so AddMonths is redundant

count(distinct {<[Date]={">$(=monthstart(today())) <$(=MonthEnd(today(),3))"}>} [Batch number])

[Nickolay1]

Thanks a lot all! It worked 🙂