Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Count the no if ID

Dear All,

 

How can I count the no of ID in the ID column as shown in the picture below? The total no of ID should be 48. Basically the id is the quotation id, i want to know the number of quotes issued in month of september.  Please advise. thanks

 

 

 

  • amitchandak's avatar
    amitchandak
    4 years ago

    Anonymous ,  a Measure

     

    Calculate(count(Table[ID]), Filter(Table, eomonth(Table[created_date],0) = eomonth(today(),-1) )) 

     

    Or you can use time intelligence with date table

    last MTD Sales = CALCULATE(count(Table[ID]),DATESMTD(dateadd('Date'[Date],-1,MONTH)))
    last month Sales = CALCULATE(count(Table[ID]),previousmonth('Date'[Date]))

1 Reply

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    4 years ago

    Anonymous ,  a Measure

     

    Calculate(count(Table[ID]), Filter(Table, eomonth(Table[created_date],0) = eomonth(today(),-1) )) 

     

    Or you can use time intelligence with date table

    last MTD Sales = CALCULATE(count(Table[ID]),DATESMTD(dateadd('Date'[Date],-1,MONTH)))
    last month Sales = CALCULATE(count(Table[ID]),previousmonth('Date'[Date]))