What is the Substitute for COUNTIFS date based formula in Power BI ?

[Anonymous]

So I have this formula in excel in my raw data (not separate totals field)

=COUNTIFS([Date range],">="&(EOMONTH(Date,-1)+1),[Date range],"<="&EOMONTH(Date,0))

Power BI however doesn't have this function. I tried to use Calculate, but it is still confusing for me to understand some of these formulas.
Can you please show me the substitute for this formula in Power BI ?

[JosefPrakljacic]

Hey @Anonymous ,

this would be the solution for your formula. 

RowCount :=
COUNTROWS ( FILTER ( TableWithDateColumn, DateColumn >= X && Datecolum <= X ) )

If this post was helpful may I ask you to mark it as solution and give it some kudos?

Have a nice day!

BR,
Josef

[Anonymous]

Hey, @JosefPrakljacic 

So what is X in your case ?

Because in my case I use EOMONTH formula, and I doesn't seem you found a solution to it.

I will try to do something with what you provided, but cannot mark it as solution, because it doesn't answer my question.

[JosefPrakljacic]

RowCount :=
COUNTROWS ( FILTER ( TableWithDateColumn, DateColumn >= EOMONTH(DateColumn,The number of months before or after the start_date) && Datecolum <= EOMONTH(DateColumn, The number of months before or after the start_date) ) )