Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Count all entries last month

Hi, im wondering that this topic is not found here.   I have a table with record ids, dates. This is related to an calendar table.   I just want to count the records which have a date from last ...
Need Help
  • ryan_mayu's avatar
    ryan_mayu
    6 years ago

    Anonymous 

    please try this

    Measure = 
VAR lastmonth=EOMONTH(today(),-2)+1
return CALCULATE(COUNT('Table'[record]),DATESBETWEEN('Table'[date],lastmonth,EOMONTH(lastmonth,0)))

     

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Sorry, maybe i was confusing it.

 

i need to count all of the values from last month.(1st - last day of month)

 

According to your example it should count "4".

 

 

Regards

ryan_mayu's avatar
ryan_mayu
Icon for Super User rankSuper User
6 years ago

Anonymous 

please try this

Measure = 
VAR lastmonth=EOMONTH(today(),-2)+1
return CALCULATE(COUNT('Table'[record]),DATESBETWEEN('Table'[date],lastmonth,EOMONTH(lastmonth,0)))

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi,

     

    im very grateful 🙂 Now it works.

     

    But im surprised that there is not just a more simple way to filter by relative .

     

    Thanks for your help!