So I have this formula in excel in my raw data
Code:
=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 ?



Just want to note it is a part of raw data, not a separate totals field.