szakharov7723
Board Regular
- Joined
- Jun 22, 2018
- Messages
- 85
- Office Version
- 2019
- Platform
- Windows
So I have this formula in excel in my raw data
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.
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.
