Forum Discussion

DeanStearn's avatar
DeanStearn
New Member
2 years ago
Solved

Countrows for previousmonth

Hi, hopefully somebody can help me with this.   I am trying to get a count of all rows for the previous month and have tried different solutions. There are similar posts to this problem, but none o...
Need Help
  • Ahmedx's avatar
    Ahmedx
    2 years ago

    pls try this

     

     

    Measure=
VAR _Start =EOMONTH( TODAY(),-2)+1
VAR _End = EOMONTH( TODAY(),-1)

RETURN
CALCULATE(
    COUNTROWS(Data),
    USERELATIONSHIP(Data[Created], 'Calendar'[Date]),
    DATESBETWEEN('Calendar'[Date] ,_Start,_End
)

     

     

Ahmedx's avatar
Ahmedx
Icon for Super User rankSuper User
2 years ago

try this

 

VAR _Start =EOMONTH( TODAY(),-1)+1
VAR _End = EOMONTH( TODAY(),0)

RETURN 
CALCULATE(
    COUNTROWS(Data),
    USERELATIONSHIP(Data[Created], 'Calendar'[Date]),

     PREVIOUSMONTH(FILTER(ALL('Calendar'[Date]), 'Calendar'[Date] >= _Start && 'Calendar'[Date] <= _End)))

 

DeanStearn's avatar
DeanStearn
New Member
2 years ago

Thank you Ahmedx , much appreciated