Forum Discussion

king98027's avatar
king98027
Frequent Visitor
2 years ago

Calculating total per quarter for specified age

I'm trying to understand the easiest way to calculate the total # of assets with a specified age at the end of each quarter.   Particularly, I want to know: count of assets that are 365 days old o...
Need Help
Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
2 years ago

king98027 So maybe something like:

Assets 365 = 
  VAR __Table = FILTER(ALLSELECTED('Table'), [Asset's Age] <= 365)
  VAR __Result = COUNTROWS(__Table)

Assets 365 to 2555
  VAR __Table = FILTER(ALLSELECTED('Table'), [Asset's Age] > 365 && <= 2555)
  VAR __Result = COUNTROWS(__Table)

??

king98027's avatar
king98027
Frequent Visitor
2 years ago

Greg_Deckler Thanks for the reply! I tried using the first measure -  looks like this was basically counting up the total number of assets that are currently 365 days old or less. What I was hoping for, with a quarter/year filter was to understand how many assets meet this criteria at each given quarter from the past. 

Here is the exact measure that was created:

 

Assets 365 = 
  VAR __Table = FILTER(ALLSELECTED('Customer Assets'), [Asset's Age] <= 365)
  VAR __Result = COUNTROWS(__Table)
  RETURN
  __Result

 

 

 

  • Greg_Deckler's avatar
    Greg_Deckler
    Icon for Community Champion rankCommunity Champion
    2 years ago

    king98027 So your Asset's Age column denotes the current age as of, for example "today", is that correct? If that is the case, then you could use the end of the quarter date and the asset's created on date to do a calculation of the asset age at the end of the quarter. Are your quarters calendar based or fiscal? 

    • king98027's avatar
      king98027
      Frequent Visitor
      2 years ago

      Greg_Deckler That is correct. The asset age would be based off today's date. Quarters are calendar based. Unclear about how to go forth.